Formula for Filtering Part Numbers

[tiziano1]

Column A of my spreadsheet has a bunch of part numbers. I would like
to create a formula in Column B such that my parts are either labeled
"American" or "Metric".

Parts that are to be labeled "American", have one (or more than one)
strings within their part number:

PT<space><space>
TF<space><space>
<space>NPTF
<space>NPS
<space>DOT<space>
<space>UNF
<space>NPT
<space>NFPA

If none of the above strings are within a part number, then the part
is to be labeled "Metric".

Can somebody please help me in creating the desired formula?

Thanks.

 

[Mangesh]

if your list is not big, this should work:

=IF(OR(ISNUMBER(FIND("PT ",A1)),ISNUMBER(FIND("TF
",A1)),ISNUMBER(FIND(" NPTF",A1)),ISNUMBER(FIND("
NPS",A1)),ISNUMBER(FIND(" DOT ",A1)),ISNUMBER(FIND("
UNF",A1)),ISNUMBER(FIND(" NPT",A1)),ISNUMBER(FIND("
NFPA",A1))),"American","Metric")


Mangesh