Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CLEAN function does not work
I have a one column which has printable/special character in each cell.
When I try to use =clean(a1), nothing happens. It just print =clean(a1) in b1. I tried F9 to recalc. but nothing is happening. Any suggestion? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CLEAN function - macro?? | Excel Worksheet Functions | |||
need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
Clean Function | Excel Discussion (Misc queries) | |||
Get out clean XML data | Excel Discussion (Misc queries) | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions |