Phone Number format (000)000-0000

[reginawhelan]

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

[Bennel_Wilson · Accepted solution]

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.

[MarqueeCrew]

@reginawhelan ,

Please try:

Regex_Replace([phone number],"\D*?(\d{3})\D*?(\d{3})\D*?(\d{4})",'($1)$2-$3')

 cheers,

 mark

[reginawhelan]

Thank you.

[bsalsbury]

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.