Formula For Separating Phone Numbers From Extensions?

[njack]

Hey Everyone,

I have a list of 7000 contacts. This list includes separate columns for first names, last names, addresses, zip codes, etc. In the phone number column the extension is also included. However, I need the extensions to be separated into their own column. Is there any trick to doing this? I am dreading having to manually go through all of this one by one! Also, if anyone does have a solution, could you explain it to me like I'm five? I'm not that great with excel. In desperate need of help!

Thanks!

 

[sericom]

We'll need to know the format of the number, or see some sample data.

 

[temens]

You could create two new columns and in one of them put the fomula:
=Left(B2,10)
Column B being where the full phone number is and 10 being the number of characters of the phone number (14 if you have parethesis and dashes) This will pull only the specified number of characters from the left side of the data in that cell.

The second column could pull only the extension, using the Right function:
=Right(B2,4)
Same principle, 4 being the number of characters on the right that makes up the extension.

After you copy the formulas down both columns, simply select those columns, copy and paste values.
This will leave you with the data and no formulas.

Hope this helps. Feel free to ask for more explaination.