clean characters

[Guest]

i have a file with multiple rows and columns and since it is a download from
another application, it has some unprintable characters. I have been using
the clean function to do one column at a time. Is there a faster way to do
this? Not all rows have values populated for all columns, so i have to drag
down the formula for each column

 

[Norman Jones]

Hi Bookworm,

See David McRitchie's TrimAll macro at:

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

If you are unfamiliar with macros, see David's 'Getting Started With Macros
and User Defined Functions' page at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm