how to delete contents of cells having specific data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear friends,
I am working on a spreadsheet having a variety of data. In some of the cells
spread across the sheet,I have a specific data ,say XYZ with comments
attached to the cells. I would like to delete the contents of these cells
along with the comments.
How could I do that.
Thanking you all.
Steve
 
Steve

There is no way to do this easily. It could be done with code. If you
didn't have comments, you could use conditional formatting to turn the cell
value white so it couldn't be seen. It would print though!

If you wish to explore the code route, try posting in the programming group

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Autofilter -> Custom -> Contains "XYZ"

Select those you want to delete F5 -> Special -> Visible cells only ->
Delete
 
Back
Top