| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Sorting Area with Merged Cells | New Users to Excel | |||
| concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
| How do I add an area code to a list of phone numbers in Excel? | Excel Worksheet Functions | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Threaded Mode
