I deal with very large spreadsheets containing extracted process data from a data logger(25000 rows and 250 columns) with Excel 2007. Some of the cells contain text messages indicating an error message recieved from the data logger. I would like to be able to remove this text from the cells and leave the cells blank automatically (with a macro that loads every time I open Excel).
Thanks in advance for your help.
Thanks in advance for your help.