| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I add a 1 to all phone #s(cells) in a column?
I have a 5000+ list of phone #s in an excel sheet. I need to add a 1 to each
of them. The numbers look like this: 9545555555. I wabt to add the 1 prefix without a dash or space. Could someone be so kind as to help this newbie??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting data in column to Phone Format | Excel Discussion (Misc queries) | |||
| Modify list of phone numbers in a column... | Excel Discussion (Misc queries) | |||
| remove the ( ) & dashes from column of phone # | Excel Worksheet Functions | |||
| How to add a 1 to existing column of phone numbers? | Excel Discussion (Misc queries) | |||
| How can I cross reference phone numbers with existing phone numbe. | Excel Discussion (Misc queries) | |||
Threaded Mode
