Ian:

The reason I say "clear contents" instead of "delete" is that deleting
a cell typically moves cells around (shift cells up, left, etc). I'm
speaking of the situation when you can either select a cell and hit
the DELETE button, or you can right click on a cell and click delete.
Right clicking will ask you how you want to shift the cells. Clicking
delete simply clears the contents.

My purpose is to get rid of the data for calculation purposes, not for
viewing, so conditional formatting will not help me (in this case).

Kevin