There may be better ways, but this will work.
Assuming you are looking for the string "Data" in cell C22 (containing
"All Data Available)", use this formula:
=IF(FIND("Data",C22)0,MID(C22,FIND("Data",C22,1), LEN("Data")),"oops")
Returns "Data" if found, otherwise returns "oops"
note: a cell reference can be used instead of the actual string,
assuming the string "Data" in in cell C26:
=IF(FIND(C26,C22)0,MID(C22,FIND(C26,C22,1),LEN(C2 6)),"oops")
returns "Data"
also note that Find is case sensitive, e.g. "data" in C26 will return
"oops".
HTH
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=383678