How to filter exact string within another string???

[ray1202]

I have this spread sheet that have more than one model numbers in a single cell.
I am trying to extract record that have a specific model number in it
how can i do it?

example:
the model numbers in the cell are
"ACT CBS CHSBBL DPPDV HTDOM HTINTL LDAP PPD PTT1 PTTSUS STD"
all in one cell, and i am looking for PTT only.
If i use filter to search for record that contain PTT, all these PTTSUS and PTT1 will show up
is there anyway i can extract record only with PTT but nothing else?

Many thanks

[shg]

Welcome to the forum.

Use a formula in an adjacent column, e.g.

=ISNUMBER(FIND(" PTT ", " " & F11 & " "))

... and filter on that.

[ray1202]

Thank you so much
I have spend hours on internet searching for this, but the extracted record always include the PTT1