Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Replacing wildcard characters in an Excel Sheet
Loomah, The Tilda sorts out the * - Thanks ! Mike and Loomah, The issue with ' and " is for descriptions of products with measurements. A global replace would work fine except that other descriptions have things like..... Type "O" Connector Nut's and Bolts' (Not my spelling!) I...- jabrett
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Replacing wildcard characters in an Excel Sheet
I have an excel spreadsheet with numerous rows of product information. I am trying to standardise the format of the descriptions. Some of these contain wildcards within the description, others have different methods of displaying the sizes ie * 5" GC1 SHEET ALUMINIUM FLUE TERMINAL needs to...- jabrett
- Thread
- Replies: 10
- Forum: VBA Visual Basic for Applications (Microsoft)
