View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Identifying cells without certain text strings

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