Hello and thank you in advanced.
this one should be simple and I've compared a few other examples online without luck.
What I'm trying to do.
- have a large report (100k lines) with a random word "adherence" in column b randomly throughout the report.
- I want to check column B and if the word adherence is in the cell to clear contents, not delete the cell.
I've tried this but I know I'm missing something small.
Hate to post on something so trivial but it's how you learn.Please Login or Register to view this content.
thanks.
Bookmarks