thanks guy's, apprecite the help.

regards from the Netherlands

"Rick Rothstein" wrote:

Here is another way for you to try...

=IF(D2="30000104",0,IF(COUNTIF(F2,"*travel*")+COUN TIF(F2,"*non
approved*")0,0,H2/520))

--
Rick (MVP - Excel)


"jan" wrote in message
...
your right.

=(IF(D2="30000104";0;IF(ISERROR(FIND("TRAVEL";F2;1 ));0;IF(ISERROR(FIND("NON
APPROVED";F2;1));0;H2/520))))

F2 contains the text, if it either contains "travel" or "non approved" the
output should be 0 if not the result must be H2/520

hope this helps

"Mike H" wrote:

Jan,

You aren't being really clear about what you want. The finds the position
of
the first letter of the string in the sentence in a1

=SEARCH("non approved",A1)

Having found that what do you want to do?

Mike

"jan" wrote:

Ron,

yes I tried to apply the standard functions but cannot solve it myself.

i need to find the string "non approved" in a sentence.

regards.

"Ron Rosenfeld" wrote:

On Sat, 13 Sep 2008 11:38:01 -0700, jan
wrote:

i'm struggling to find a word in a specif text string, any ideas?

thanks

Did you try the FIND or SEARCH worksheet functions?
--ron