how to delete contents of cells having specific data

S

steve

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
 
N

Nick Hodge

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
[email protected]
 
M

Morrigan

Autofilter -> Custom -> Contains "XYZ"

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