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
 
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?
 
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)
 
Back
Top