| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help cleaning up some Strings
Excel 2002
Windows XP Pro Suppose in column A I have the following kinds of String values 12________ 24___ 17______ 34__ 24____ I'd like to write a Macro that will remove all of the underscores (char(95) i believe). How would you go about doing that? The number of underscores in any given string will vary, but they'll always be at the end of the string. TIA -gk- -- ================================================= The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone. -Greg Kot in Wilco Learning How To Die- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
| Cleaning Up Data | Excel Discussion (Misc queries) | |||
| How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
| Spreadsheet cleaning | Excel Discussion (Misc queries) | |||
| Cleaning up data | Excel Programming | |||
Threaded Mode
