Assuming the 7 digit numbers are running in A1 down

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
ups.com...
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