I have a long string of text in cell B1 and I want to be able to analyse it using a formula to return a value in B1.
Basically I want excel to search the text in A1 and if A1 contains "IUG" or "Extended" then the result to return in B1 is "IUG"
Does anyone know how I can do this?
thanks
Bookmarks