View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Michael M
 
Posts: n/a
Default 8500 cells with phone number(7 char.), wishing to add area code (1

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
" wrote:

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