You are posting in programming group.

Do you want to use VBA to find the string?

And what will you do with the result when you have found the string?

Do you want to replace with another? Highlight the cell? Highlight the
string within the sentence?

Without programming..............................

EditFindWhat: not approved

Make sure you don't have "match entire cell contents" enabled.


Gord Dibben MS Excel MVP


On Sat, 13 Sep 2008 11:51:01 -0700, 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