| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data,Text to Columns Clean up
Often when I do a text to columns
the text has trailing spaces like xyz____ Viewable at xyz but len(a1) = 7 <<< the underscore characters represents trailing spaces not the literal underscore as shown) Using a regular trim(A1) doesn't work. What other ops are available? TIA, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Clean-up Macro | Excel Discussion (Misc queries) | |||
| Clean text before the @ sign in an Email Address | Excel Discussion (Misc queries) | |||
| Data Clean Up | Excel Discussion (Misc queries) | |||
| clean up data | Excel Discussion (Misc queries) | |||
| Get out clean XML data | Excel Discussion (Misc queries) | |||
Threaded Mode
