Excel - seperating area codes from numbers

Microsoft Office excel 2007 - upgrade
May 9, 2010 at 23:29:11
Specs: Windows 7
the do not call list I have has the Area code separate from the phone number. My list has the area code and phone number all as one all joined together. I want the area code in one column and the phone number in another column in an excel spread sheet.

See More: Excel - seperating area codes from numbers

Report •

May 10, 2010 at 05:59:16
It would help if we knew how the numbers you want to separate are displayed:

(209) 555-1234

In any case, you should be able to use the LEFT(), RIGHT() and/or MID() functions to split up the numbers:

e.g. With (209) 555-1234 in A1, use this:

=MID(A1,2,3) to get 209


=RIGHT(A1,8) to get 555-1234

Look up these functions in Excel Help to see how they are used.

Report •

May 10, 2010 at 08:00:06
The example is the same as the top one with the Brackets. I need to remove the brakets athe dash.

Report •

May 10, 2010 at 09:21:56
re: "I need to remove the brakets athe dash."

Is this supposed to say:

"I need to remove the brackets and the dash."?

If so, what do you want the output to look like?

2095551234 or 209 555 1234 or 209 5551234 or ???

A Posting Tip:

Since we can't see your workbook from where we're sitting (or read minds) it helps us help you if you tell us exactly what you are starting with and exactly what you want the output to look like.

Otherwise, we could toss out possible solutions all day, none of which will fit your needs.

Office Forum Moderator

Report •

Related Solutions

May 10, 2010 at 09:30:54
the phone numbers starts like:
(403) 123-5678. I need the number to look like 1234567 without the Area Code.

Report •

May 10, 2010 at 10:03:54
You can't get 1234567 from (403) 123-5678 very easily.

I assume you mean 1235678.

With (403) 123-5678 in A1, and assuming there are no leading or trailing spaces, this should work:

=MID(A1,7,3) & RIGHT(A1,4)

I suggest you read up on these functions in the Excel Help files so you can adjust them as needed.

Report •

Ask Question