Hi,
I need a formula to remove special characters (i.e. (),#*&!).
Thanks and have a good one!
Alex
Hi,
I need a formula to remove special characters (i.e. (),#*&!).
Thanks and have a good one!
Alex
Regards,
Alex
Try this...
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),",",""),"#",""),"*",""),"&",""),"!","")
Replace the reference A1 to your desired cell
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Try This link -
It might help!
http://www.mrexcel.com/forum/excel-q...es-one-go.html
Deep
Cheers!
Deep Dave
Thanks sixthsense for the quick reply.
Sorry I did not include specifics... I need to remove () from this string (08) 1234 1234.
Thanks
In A1 Cell
(08) 1234 1234
In B1 Cell
Formula:Please Login or Register to view this content.
Gotcha! Thanks...
Glad it helps you and thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks