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