Search cell for any of 6 criteria
 

Have cells containing numerous text strings.
If the cell contains within its contents (which also has other
characters:)

.12 or .19 or TRS or PKI or .099 or PCI

Want to return TRUE, or FALSE.

Tried incarnations of this, but it doesn't behave.
=ISNUMBER(SEARCH("*.12*","*.19*","*TRS*","*PKI*"," *.099*","*PCI*",A1))

Thanks for ideas.

Pierre

Search cell for any of 6 criteria
 

Try this:
=OR(COUNTIF(A1,"*"&{".12",".19","TRS","PKI",".099" ,"PCI"}&"*"))

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"Pierre" wrote in message
...
Have cells containing numerous text strings.
If the cell contains within its contents (which also has other
characters:)

.12 or .19 or TRS or PKI or .099 or PCI

Want to return TRUE, or FALSE.

Tried incarnations of this, but it doesn't behave.
=ISNUMBER(SEARCH("*.12*","*.19*","*TRS*","*PKI*"," *.099*","*PCI*",A1))

Thanks for ideas.

Pierre

Search cell for any of 6 criteria
 

On Mar 24, 11:16*am, "Ron Coderre" wrote:
Try this:
=OR(COUNTIF(A1,"*"&{".12",".19","TRS","PKI",".099" ,"PCI"}&"*"))

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"Pierre" wrote in message

...



Have cells containing numerous text strings.
If the cell contains within its contents (which also has other
characters:)

.12 or .19 or TRS or PKI or .099 or PCI

Want to return TRUE, or FALSE.

Tried incarnations of this, but it doesn't behave.
=ISNUMBER(SEARCH("*.12*","*.19*","*TRS*","*PKI*"," *.099*","*PCI*",A1))

Thanks for ideas.

Pierre- Hide quoted text -

- Show quoted text -


Ron, thank you!

Pierre

Search cell for any of 6 criteria
 

Amending your formula...

=OR(ISNUMBER(SEARCH({".12",".19","TRS","PKI",".099 ","PCI"},A1)))

Hope this helps!

Domenic
www.xl-central.com

In article
,
Pierre wrote:

Have cells containing numerous text strings.
If the cell contains within its contents (which also has other
characters:)

.12 or .19 or TRS or PKI or .099 or PCI

Want to return TRUE, or FALSE.

Tried incarnations of this, but it doesn't behave.
=ISNUMBER(SEARCH("*.12*","*.19*","*TRS*","*PKI*"," *.099*","*PCI*",A1))

Thanks for ideas.

Pierre