Is there a formula that would format all different types of formatted phone numbers into (000)000-0000?
For example: A file may have the following formats:
1231231234
123-123-1234
123123-1234
123-1231234
Hi,
Let me know if this works.
Output:
The main part is the formula tool with this formula:
Attached workflow for your reference.
Regards
Benn
P.S: In case this solves your query, kindly mark it as a solution.
@reginawhelan ,
Please try:
Regex_Replace([phone number],"\D*?(\d{3})\D*?(\d{3})\D*?(\d{4})",'($1)$2-$3')
cheers,
mark
Thank you.
What if you had some phone numbers that didn't have the area code populated? Maybe to get the end result to be like (000) 123-4567.
How do I apply this formula to a column called Telephone_Number.
Please let me know.
Thanks
Lesia
How can I use this formula but the date format would be:
(000) 000-0000
Any help is appreciated.
