Removing with formula

  • Thread starter Thread starter yovation
  • Start date Start date
Y

yovation

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
 
embed extra SUBSTITUTEs with the other characters.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LEFT(D2,3) but no spaces 4
=IF ..OR.. =IF 7
Formula error 4
Choosing different cell values by user clicking a button 5
trim, chr(10) 24
Re: Formula to Remove Special Characters 5
Manipulating Strings in a Macro 2
Removing Quotes from Range Names 7

Back
Top