Hello Sir,
i have names of companies with comma, dot, ?, &
i want to replace with blank only that character
how do i achieve this in excel formula.
Hello Sir,
i have names of companies with comma, dot, ?, &
i want to replace with blank only that character
how do i achieve this in excel formula.
Last edited by mohan.r1980; 08-31-2016 at 07:46 AM.
One way:
=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,","," "),"?"," "),"."," "),"&"," "))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi,
CTRL + H and replace any special character (*?>":...) using "~" before
~, or ~. or ~? or ~?
Dear Glenn Kennedy,
thanks to reply
if suppose name contain !, # or another special character then every time i have change the formula manualy.
is there is a way to find out the special character and replace it with blank??
Hello 20rin
thanks to reply
is it possible in formula??
Here's a possible VBA solution for you. It is sufficiently flexible to allow you to replace characters with a space, a blank, or any other character.
thank you very much Glenn Kennedy
its working fine.
You're welcome and Thanks for adding Reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks