Forum Discussion
how to find occurences of a word before or after a specific word in an excel cell
Hello Everyone, I am facing an issue for some time and I have realised that there is no better place to ask for a solution of it than this place. So, here it goes. suppose there is an address li...
Hi,
As simple variant
=IFERROR(IF(SEARCH("opposite",A1)<SEARCH("mobile",A1), "before", "after"),"no such pair")