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

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

---
Regards,
Norman



"bookworm" wrote in message
...
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