Replacing punctuation mark with space

QuestionEdit

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

AnswerEdit

=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 " "