I tried both Search and Find but the problem is the I have few options for
the strint to search and these functions don not approve "OR" function.

In other words I want to find "AA" Or "BB" Or "CC" within String "DFAA GTY".
Expected result would be "AA"

"Barb Reinhardt" wrote:

Have you considered the SEARCH function?

"Nir" wrote:

I need to find multiply strings within ONE string