Formula Help on Phone Number Formatting

[briem]

I am looking for help creating a formula field to change the format that phone numbers appear in.

On Airtable, the phone field automatically formats phone numbers as: (555) 555-5555.

I need the phone numbers to be formatted as follows instead: +1 555-555-5555.

Please help!

[Tyler_Thorson]

This formula should work.

"+1 " & SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Phone #}, '(', ''), ')', '')," ","-")

It finds and removes the parentheses with the SUBSTITUTE function, then finds the remaining " " (Space) and replaces it with "-". Then you just use the "&" operator to add "+1 " to the front.

Hope that helps!