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

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