Formula for removing special characters.

[alexgempesaw]

Hi,


I need a formula to remove special characters (i.e. (),#*&!).


Thanks and have a good one!



Alex

[:) Sixthsense :)]

Try this...

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),",",""),"#",""),"*",""),"&",""),"!","")

Replace the reference A1 to your desired cell

[NeedForExcel]

Try This link -

It might help!

http://www.mrexcel.com/forum/excel-q...es-one-go.html

Deep

[alexgempesaw]

Thanks sixthsense for the quick reply.

Sorry I did not include specifics... I need to remove () from this string (08) 1234 1234.


Thanks

[:) Sixthsense :)]

In A1 Cell
(08) 1234 1234

In B1 Cell

Please Login or Register  to view this content.

[alexgempesaw]

Gotcha! Thanks...

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep