deleting duplicate cells in several columns

B

bullseye

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

Lori

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.
 
B

bullseye

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.
 
L

Lori

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
 
B

bullseye

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.
 
Top