| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing with formula
I am trying to clean some data. I need to remove characters like &
' / etc.... This is what I have so far. It removes all spaces from the cell. =TRIM(CLEAN(LOWER(SUBSTITUTE(CatCleaned!D370, " ", "")))) Do you have any suggestions on adding to the formula to remove the other characters? Thank you. yovation |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Removing with formula
embed extra SUBSTITUTEs with the other characters.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "yovation" wrote in message ups.com... I am trying to clean some data. I need to remove characters like & ' / etc.... This is what I have so far. It removes all spaces from the cell. =TRIM(CLEAN(LOWER(SUBSTITUTE(CatCleaned!D370, " ", "")))) Do you have any suggestions on adding to the formula to remove the other characters? Thank you. yovation |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing #N/A from formula results | Excel Worksheet Functions | |||
| to create a formula by removing RC[number] | Excel Discussion (Misc queries) | |||
| Need formula help! Removing a neg# & #DIV/0! | Excel Discussion (Misc queries) | |||
| keep number when removing formula | Excel Discussion (Misc queries) | |||
| Cannot enter formula in a cell after removing a circular formula | Excel Worksheet Functions | |||
Linear Mode
