Skip to Content
0

Remove Phone Number Special Character (Replace?)

Jul 19, 2017 at 03:37 PM

33

avatar image
Former Member

Hello Experts,

I'm trying to do a replace on all the characters on our phone number field. I can do a Replace([Phone];"-";"") to replace all the dashes. Our number field however have other characters such as (, ), space.

How do I do multiple replace on 1 single field or is there another way of doing it?

Thanks!

10 |10000 characters needed characters left characters exceeded

Hi,

You can do

=Replace(Replace(Replace([Phone];"-";"");",";"");" ";"")

Thanks,

Jothi

0
Former Member

Thank you. This works.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers