Given a list of phone numbers, and the need to turn these into international format,  you may need to combine some formulas.

Example:

Original phone number in Cell A2:     2223334444
Desired format:    +1 (222) 333-4444

Excel formula:
=CONCATENATE(“+1 (“,LEFT(A2,3),”) “,MID(A2,4,3),”-“,MID(A2,7,4)))

This is my site Written by Tim Jolley on August 30, 2011 – 5:12 pm