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