How do I add digits to all numbers in a column?

  • Thread starter MysticalWaters79
  • Start date
M

MysticalWaters79

I have a large database of phone numbers. some are 10 digits, and some are
only 7. I need all numbers that are 7 digits to have the same area code
added to the front. Is there a way to do this other than manually?
 
T

T. Valko

What format are the phone numbers in?

Show us both a 10 digit number and a 7 digit number.
 
F

Fred Smith

I would create a new column with the new numbers in them. How you convert
them depends on how your numbers are store. If they are straight text, you
can use something like:
=if(len(a1)=10,A1,"306"&a1)

If they have some other format, you can adapt the above, or post back with
details.

Regards,
Fred
 

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

Working with numbers in Excel-Specify # of digits 6
Covert 9 digits to 10 in excel 2
Loop 1
number format 2
Numbers in a column won't add up 1
Maximum amount of numbers in one Cell 2
duplicate numbers in a column 2
How can I sort a list of numbers by the last 4 digits? 2

Top