Help

Formula Help on Phone Number Formatting

1061 1
cancel
Showing results for 
Search instead for 
Did you mean: 
briem
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1
Tyler_Thorson
6 - Interface Innovator
6 - Interface Innovator

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!