8500 cells with phone number(7 char.), wishing to add area code (10 char.)

[moparz]

I am wanting to edit a spread sheet that contains a call list of 8500
phone numbers which are 7 digit. In going to 10 digit dialing, I need
to add the same 3 digit area code to each cell in the row.
Is there an easy way to do this for someone who's not very good in
excel?

e.g.

4567890 for the phone number. wishing to convert all data in column to
1234567890.

TIA for any assistance

 

[Max]

Assuming the 7 digit numbers are running in A1 down

Try in B1: ="123"&A1
Copy B1 down

 

[Max]

In case there's a need to pad col A to 7 digits
(eg: "6" digit numbers with dropped leading zeros)

Put instead in B1, and copy down:
="123"&TEXT(A1,"0000000")

Then copy col B and overwrite col A with a:
Paste special > Check Values > OK

---

 

[Guest]

One way
Put your 3 digit code ina seperate location say E1.
If 7 digits code is in A1
put in B1
=E1&A1 and copy down

HTH
Michael M

 

[moparz]

Thanks everyone. I got it posted and worked.

One diligent person started entering area codes manually so I have a
few double area code entries as a result, but I can just manually
delete those which is a heck of alot easier than adding a area code to
8500 entries.

GREAT group here!!

Thx all.

J

 

[Pete_UK]

You could save yourself manally converting the numbers back by amending
your formula to:

=IF(LEN(A1)>7,A1,E1&A1)

Hope this helps.

Pete

 

[moparz]

kewl, will check that out.
THX!!!!!