| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
In a blank column try
=1&A1&7741 Copy down. Copy whole new column. Paste special Values over old numbers. Is that what you're trying to do? "Luke" wrote: how do i add "1" before each fax number and ",,7741" at the end of each one? we have to dial one to dial long distance and we have a code to use the long distance in our office. please help quickly. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numbers in a column that have 3 decimal places | Excel Worksheet Functions | |||
| Adding more than 30 numbers in a column | Excel Worksheet Functions | |||
| Excel Adding duplicated numbers together | Excel Discussion (Misc queries) | |||
| Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
| adding only positive numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
