Assuming you have formulas that return these, select the range,hit F5, click
special and select formulas and uncheck everything but errors, click OK and
do editclearall (or delete them)

Regards,

Peo Sjoblom

"BLW" wrote:

does anyone know a way or have a macro that will delete certain text from a
sheet of cells. i need to get rid of all of 'N/A' cells in a list, and i am
not sure how to do this.