Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 8500 cells with phone number(7 char.), wishing to add area code (10 char.)

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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default 8500 cells with phone number(7 char.), wishing to add area code (10 char.)

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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default 8500 cells with phone number(7 char.), wishing to add area code (10 char.)

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


  #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


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

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



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

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

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

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM
Sorting Area with Merged Cells prizm1 New Users to Excel 3 September 10th 05 11:49 PM
concatenating and formatting area code and phone number columns sherri Excel Worksheet Functions 4 September 1st 05 09:59 PM
How do I add an area code to a list of phone numbers in Excel? PPuser Excel Worksheet Functions 2 April 5th 05 08:35 PM
Make Change Case in Excel a format rather than formula Kevin Excel Worksheet Functions 1 March 18th 05 09:53 PM


All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"