View Single Post
  #3   Report Post  
swatsp0p
 
Posts: n/a
Default


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