deleting duplicate cells in several columns
 

What commands can I use to identify and delete the same information (say
ABC) in a variety of cells in multiple (5) columns?


--


If you wish to reply using e-mail, please use my gmail address and send
it to RassBariaw.

deleting duplicate cells in several columns
 

Edit Find: "ABC" Find All.

Select an item in the find list then press ctrl+a, click on sheet and
then press the delete key.


bullseye wrote:

What commands can I use to identify and delete the same information (say
ABC) in a variety of cells in multiple (5) columns?


--


If you wish to reply using e-mail, please use my gmail address and send
it to RassBariaw.

deleting duplicate cells in several columns
 

Having difficulty with your instructions. I went to Edit, then Find,
but where is Find All? ctrl+a highlights the whole sheet and deleting
from there deletes the whole worksheet. I use Excel 2000.


Lori wrote:
Edit Find: "ABC" Find All.

Select an item in the find list then press ctrl+a, click on sheet and
then press the delete key.


bullseye wrote:

What commands can I use to identify and delete the same information (say
ABC) in a variety of cells in multiple (5) columns?

deleting duplicate cells in several columns
 

Ah - you should upgrade to 2002 or higher.

Otherwise maybe use Data Filter AutoFilter, select custom and
contains "ABC" and delete the items in the list on each of the five
columns.

Or to just delete the information Edit Replace Find: ABC Replace:
(blank): Replace All

bullseye wrote:

Having difficulty with your instructions. I went to Edit, then Find,
but where is Find All? ctrl+a highlights the whole sheet and deleting
from there deletes the whole worksheet. I use Excel 2000.


Lori wrote:
Edit Find: "ABC" Find All.

Select an item in the find list then press ctrl+a, click on sheet and
then press the delete key.


bullseye wrote:

What commands can I use to identify and delete the same information (say
ABC) in a variety of cells in multiple (5) columns?

deleting duplicate cells in several columns
 

Thank you for the suggestion; I used it for a while but abandoned it
because I started to sort the columns first (the first three in an
ascending order, and the last two in descending order) and I ended up
with this value at the bottom of the columns (but the columns have
different numbers of rows). I believe data/filter would work if all
else fails.

Lori wrote:
Ah - you should upgrade to 2002 or higher.

Otherwise maybe use Data Filter AutoFilter, select custom and
contains "ABC" and delete the items in the list on each of the five
columns.

Or to just delete the information Edit Replace Find: ABC Replace:
(blank): Replace All

bullseye wrote:

Having difficulty with your instructions. I went to Edit, then Find,
but where is Find All? ctrl+a highlights the whole sheet and deleting
from there deletes the whole worksheet. I use Excel 2000.


Lori wrote:
Edit Find: "ABC" Find All.

Select an item in the find list then press ctrl+a, click on sheet and
then press the delete key.


bullseye wrote:

What commands can I use to identify and delete the same information (say
ABC) in a variety of cells in multiple (5) columns?




--


If you wish to reply using e-mail, please use my gmail address and send
it to RassBariaw.