Kristen

If your 'dirty' data is say in A1:A100 in B1 enter

=CLEAN(A1)

and copy it down. Then copy that data and EditPaste Special...Values over
the original and delete the column B

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Kristen" wrote in message
...
I am trying to use the CLEAN formula in Excel which removes unprintable
characters. I can do it for one cell at a time by using the formula
=Clean(cell reference) but I need to do it for a range of cells as I have
unprintable characters throughout my entire worksheet. I've tried the
following formula =Clean(1st cell reference:last cellreference) but I get
a
#Value error. Any ideas or suggestions would be GREATLY appreciated!

Kristen