Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I delete 100 account numbers from a spreadsheet colume wer.
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 |
#2
|
|||
|
|||
Hi
use a helper column, in a column to the left of your numbers put in (assuming your numbers start in A1) =RIGHT(A1,5) fill down as needed (move mouse over bottom right corner of the cell until you see a + then double click), (once you're happy with the result) select column B and copy it click on A1 and choose Edit / paste special - values and click OK now the account numbers will have been replaced with the last 5 digits of the account numbers and you can delete column B. Hope this helps Cheers JulieD "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 |
#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 |
Reply |
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 |