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