deleting certain text from cells

B

BLW

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.
 
P

Peo Sjoblom

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 edit>clear>all (or delete them)

Regards,

Peo Sjoblom
 
Top