software

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 assistanceAssuming the 7 digit numbers are running in A1 down

Try in B1: =quot;123quot;amp;A1
Copy B1 down

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
gt; wrote in message ups.com...
gt; I am wanting to edit a spread sheet that contains a call list of 8500
gt; phone numbers which are 7 digit. In going to 10 digit dialing, I need
gt; to add the same 3 digit area code to each cell in the row.
gt; Is there an easy way to do this for someone who's not very good in
gt; excel?
gt;
gt; e.g.
gt;
gt; 4567890 for the phone number. wishing to convert all data in column to
gt; 1234567890.
gt;
gt; TIA for any assistance
gt;
In case there's a need to pad col A to 7 digits
(eg: quot;6quot; digit numbers with dropped leading zeros)

Put instead in B1, and copy down:
=quot;123quot;amp;TEXT(A1,quot;0000000quot;)

Then copy col B and overwrite col A with a:
Paste special gt; Check Values gt; OK
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
One way
Put your 3 digit code ina seperate location say E1.
If 7 digits code is in A1
put in B1
=E1amp;A1 and copy down

HTH
Michael M
quot; wrote:

gt; I am wanting to edit a spread sheet that contains a call list of 8500
gt; phone numbers which are 7 digit. In going to 10 digit dialing, I need
gt; to add the same 3 digit area code to each cell in the row.
gt; Is there an easy way to do this for someone who's not very good in
gt; excel?
gt;
gt; e.g.
gt;
gt; 4567890 for the phone number. wishing to convert all data in column to
gt; 1234567890.
gt;
gt; TIA for any assistance
gt;
gt;

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.

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

=IF(LEN(A1)gt;7,A1,E1amp;A1)

Hope this helps.

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