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