Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim hidden characters?
I have an imported table and several of the fields have extra line
feeds or other hidden characters. This makes it impossible to sort the table. Is there any sort of way to trim off these extra characters at the spreadsheet level so I can do a sort? I can write a custom function to remove anything that's not A-Z,0-9 but if there's a feature at the spreadsheet level, that would be great. Any ideas?! Thanks. John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View hidden characters | Excel Discussion (Misc queries) | |||
Viewing hidden characters | Excel Discussion (Misc queries) | |||
How do you trim characters? | Excel Worksheet Functions | |||
Help! Can't get rid of hidden characters | Excel Discussion (Misc queries) | |||
trim a string by specific number of characters | Excel Discussion (Misc queries) |