Try this:

C4: =IF(MAX(--(RIGHT(B4,2)={"DT","TH"})),"",B4)
Copy that formula down as far as you need.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"jay" wrote in message
...
Hello,

I have a list of codes in column B4:B263 as follows:

07129 B4 DT
07129 B4
07129 B4 TH
07555 A1
06999 A1 DT
etc.

I'd like to set up a list in column C that only includes the rows in
column
B without the text "DT" or "TH", i.e. C4, C6 and C8 would be empty. Any
suggestions would be appreciated.

Thanks,

Jay