| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Ndubuisi
If the account number is in say A1, then in a spare cell to the right type =RIGHT(A1,5) and enter, now copy down the 100 rows and copy this new account number, select the old account numbers and Editpaste special...Values the new ones over the top of the old. Now delete the column you used to create the new numbers -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Ndubuisi Azuogu" <Ndubuisi wrote in message ... How do I delete 100 account numbers from a spreadsheet colume were it only leaves the last 5 digits of all the accounts with out having to physicaly delete each account manually |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| I have a set of numbers in an excel spreadsheet and want to find t | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| How do I setup a list box that has several account numbers so use. | Excel Worksheet Functions | |||
| Add numbers for duplicate entries then delete | Excel Worksheet Functions | |||
Threaded Mode
