Hi John,

Maybe this is of use to you:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"robotman" wrote in message oups.com...
|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
|