Search cell for any of 6 criteria

[Pierre]

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

 

[Ron Coderre]

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]

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

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)











- Show quoted text -

Ron, thank you!

Pierre

 

[Domenic]

Amending your formula...

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

Hope this helps!

Domenic
www.xl-central.com