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
Solved! Go to Solution.
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.