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
Bookmarks