How do i find text in a sentence in different colomns ?
I have colomn P2 for the formula
I have colomn Q2 until AC2 for the sentences, the sentences are random within these colomn
So I just want to find one word "fixed" within those sentences in colomn Q2 until AC2 and return the word either "fixed" or "not fixed" to colomn P2. If we can't find the word fixed, so we asumed that it's "not fixed".
Bookmarks