| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CLEAN Formula
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Threaded Mode
