how to delete contents of cells having specific data

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


"steve" <[email protected]> wrote in message
news:[email protected]...
> 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