How do I add an area code to a list of phone numbers in Excel?

G

Guest

I have multiple lists containing phone numbers that don't include an area
code. Is there a way to automatically add the same area code to the list?
Thanks
 
J

jiwolf

yes. Assuming your list is is column A, with the first entry in cell A1, and you wish to add area code "01902"

enter the following into cell B1, ="01902"& A1 then copy and paste down.
 
J

Jason Morin

Try something to the effect of:

=IF(LEN(A1)<=8,"(404) "&A1,A1)

HTH
Jason
Atlanta, GA
 

Ask a Question

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.

Ask a Question

Similar Threads

Excel "Local" phone numbers in a list do not include area code. How to add? 2
How do I add parenthesis to my phone number list -the area code? 7
Function to uniformerly format different phone numbers 7
Adding area codes only to phone numbers missing an area code 4
Count If And Contains 8
Trying to sort a column of information... please help 1
FREQUENCY Formula Question 2
adding area code when synchronizing with mobile 1

Top