View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
 
Posts: 340
Default 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.