Microsoft Office Forums - View Single Post - Converting Phone Numbers Question

Thread: Converting Phone Numbers Question

View Single Post

Old

06-04-2012, 01:53 PM

certified_techy certified_techy is offline

certified_techy is offline

certified_techy uses Windows 7 64bit

Windows 7 64bit certified_techy uses Office 2007

certified_techy uses Office 2007

Office 2007

Novice

The original poster

Join Date: Apr 2012

Location: Nashville, TN

Posts: 2

certified_techy is on a distinguished road

Default

So, how would that look with a phone number in it? And how could I do a "find and replace" and get that added to the front (which is where I'm assuming it's supposed to go)?

Would it look like "=LEFT(A1,3)&"-"&MID(A1,4,3)&"-"&RIGHT(A1,4)1234567890" ?

Reply With Quote