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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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
News 419m phone numbers leaked in Facebook data breach 3
Countif Criteria Reference Cell 4
concatenating and formatting area code and phone number columns 4
VLOOKUP function with embedded LEFT 7
Adding area codes only to phone numbers missing an area code 4

Back
Top