Excel "Local" phone numbers in a list do not include area code. How to add?

I

Ida N Corrigan

Joined
Feb 7, 2018
Messages
1
Reaction score
0
I have a list containing phone numbers and some do not include an area code.
Is there a way to automatically add the same area code to the numbers that are missing area codes?
Thanks
 
Becky

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Welcome to the forum :)

Yep, that is certainly possible. Are all the numbers without area codes the same length? Will they all need the same area code added?
 
A

AmjiBhai

Joined
Feb 21, 2018
Messages
216
Reaction score
86
Assuming phone numbers are listed in column A....A1 is the starting cell
Put your city code in cell F1.

In Column B copy this formula...
=IF(LEFT(A1,LEN($F$1))=$F$1,A1,$F$1&A1)
 

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

Adding area codes only to phone numbers missing an area code 4
Word Create a Phone Book using MailMerge in word 2007 0
Excel How to add numbers in same cell? 2
How do I add an area code to a list of phone numbers in Excel? 2
adding area code when synchronizing with mobile 1
Can Vba workout if a selection is part of a group? 0
Excel I have a large (62pages) excel file that needs to be sent as a pdf but it is only exporting half !? 2
Update query for area codes 3

Top