| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CLEAN function does not work
Mac,
Do you see =CLEAN(A1) in the cell, or the value in A1. It may be that there is a space or spaces before the =. -- HTH Bob Phillips "mac" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CLEAN function does not work
Is either A1 formatted as Text or the cell with the formula formatted as
text. If so, format them as general. Then re-enter the formula. Regards, Tom Ogilvy mac wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
