First post and I'm very excited about it - I am trying to search multiple text strings in a single cell and return the string if found. Is this possible? I have tried to nest if, mid and find statements but am not getting results past the first if(mid(find statement. The cell I am searching could contain "YTD AAA KNI", I want to search it for "AAA" or "BBB" and in this case return the "AAA". Thanks!