ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   deleting certain text from cells (https://www.excelbanter.com/excel-worksheet-functions/26721-deleting-certain-text-cells.html)

BLW

deleting certain text from cells
 
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.

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



All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com