G
Guest
I have an Excel list of phone numbers that I need to add parenthesis around
the area code. Anyone know how to do this? The list is about 3,000 numbers.
the area code. Anyone know how to do this? The list is about 3,000 numbers.
I have an Excel list of phone numbers that I need to add parenthesis around
the area code. Anyone know how to do this? The list is about 3,000 numbers.
Harlan Grove said:Alan wrote...I have an Excel list of phone numbers that I need to add parenthesis around
the area code. Anyone know how to do this? The list is about 3,000 numbers.
Are these phone numbers stored as numbers or as text, and do you just
need them to appear as (###) ###-#### ? If they're numbers and you just
need them to appear with area codes in parentheses, you could do that
with the custom number format
[>=10000000](#) 000-0000;000-0000
If your phone numbers are stored as text, how are they formatted?
....the text to columns would still get what you're looking for, it will
require you to insert some blank columns after the column that the
numbers are in now. try this, insert three blank columns after the
column that the phone numbers are currently in. then data -> text to
columns, choose delimited, then other and put - is as the delimiter
then on the next screen choose general as the column data format, then
click finish. this will split up the three parts of the phone number
into three seperate columns, then in the fourth column, enter the
equation ="(" & A1 ") " & B1 & "-" & C1
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.