Replacing punctuation mark with space

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:53 PM GMT

Question

Here i am once again, with a irritating problem. I have a long list of destination name that contains character like, comma ",", full stop ".", and other character's like "/,.,',',:," i want to replace them with space or blank inside a formula whenever they appears, will this be possible?

Thank you once again for your kind responds.

Humble Sami

Answer

=substitute(substitute(substitute(substitute(substitute(A1,","," "),"."," "),":"," "),"/"," "),"'"," ")


I put this in cell A1

",", full stop ".", and other character's like "/,.,',',:,"


and the formula produced

" " full stop " " and other character s like " "

Advertisement

©2020 eLuminary LLC. All rights reserved.