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.

It would help if we knew how the numbers you want to separate are displayed: (209) 555-1234

209-555-1234

2095551234

etc.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

and

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

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

The example is the same as the top one with the Brackets. I need to remove the brakets athe dash.

thanks

re: "I need to remove the brakets athe dash."Is this supposed to say:

"I need to remove the brackets?andthe 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.

DerbyDad03

Office Forum Moderator

the phone numbers starts like:

(403) 123-5678. I need the number to look like 1234567 without the Area Code.

You can't get 1234567from(403) 123-5678very 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.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History