Substitute Character

Joseph · Dec 8, 2003

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

Chip Pearson · Dec 8, 2003

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