Is there a way to find all cells containing a certain text without using the simple find comand?
I want to find all cells containing the word test. sometimes it is XXtest or aatest or testb. There are hundreds of these possibilities and I want to find all of them. Is there a formula that will look for this. I am hoping to use it to set a flag next to this cell.
Thanks
I want to find all cells containing the word test. sometimes it is XXtest or aatest or testb. There are hundreds of these possibilities and I want to find all of them. Is there a formula that will look for this. I am hoping to use it to set a flag next to this cell.
Thanks