Hi all,
I have a column with text that I need to extract into another column. I'm using an IFS(Search) formula to do this which is working for some of the text in my first logical test but not the second even though the text is present.
formula
=IFS(SEARCH("GrainPro",M92),"GrainPro...