Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula Help on Phone Number Formatting

116 1
Showing results for 
Search instead for 
Did you mean: 

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

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!