| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alter Account numbers
I have a list of approx 9000 account numbers that are in the format:
#####-###-### (ex: 35000-455-876) I would like to add "03-" to the front of the numbers and delete the last "-###", so the final format would be: 03-#####-### (ex: 03-35000-455) Any suggestions? I can't seem to figure out the concantenate function. Thanks! Ann |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation of Account Numbers | Excel Discussion (Misc queries) | |||
| incrementing account numbers | Excel Discussion (Misc queries) | |||
| Generate new account numbers? | New Users to Excel | |||
| How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
| Sorting Account Numbers | Excel Worksheet Functions | |||
Threaded Mode
