Hi, I have a text in a cell about a recent auto show. How can I find out if the word 'innovation' is being associated with a brand such as 'BMW'?
I have tried doing a proximity search by using the SEARCH function google sheets. However a search for the word 'BMW' only reveals the position where the first character of the word appears, not the second instance. Please help, thanks.
Solved by E. C. in 19 mins