Substitute Character

  • Thread starter Thread starter Joseph
  • Start date Start date
J

Joseph

I need to search a word for the characters,"/", " "
(blank) and "-" and remove them. How can I do this with a
single worksheet formula ?

For eg: If the word is

Yes / No

The result should be

YesNo
 
Joseph,

You can nest the SUBSTITUTE functions. For example,

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ",""),"/",""),"-","")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

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

Excel Create a New line in a Word Link without double "" around result 0
FIND 2nd character in a string 5
Excel VBA 1
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string 6
Difficulty cleaning some char(63) characters 1
Validation List Dependencies 2
Can I use "*xyz" in a formula 2
substitution: a better method? 8

Back
Top