If doesn't contain certain text then delete row.

[Distsyst]

I have found codes for deleting a row if a column contains a set of letters, but I can't seem to find anything that would delete the row if the column doesn't contain certain text.

Sample data:
*A****B****C****D****E*******F
4/23*james**1hr**r32**RTS_21***9
4/23**Leo***2hr**lpl***RPLN*****23




I am trying to keep all rows that have any of the following text in column E:
RTS_11
RTS_12
RTS_21
RTS_22
RTS_32
RTS_41
RTS_42
RTS_51
RTS_52


Is this possible or will I need to make a macro that deletes if column E contains certain text?
Sorry it looks messy =[
Thank you in advance for any and all help, I really truly appreciate it.

 

[vds1]

Select the column containing the sample data,

Goto Data > filter >select drop down > Text Filter > Contains > Type "RTS"

 

[Peter_SSs]

Welcome to the MrExcel board!

My reading of this is a bit the other way around to vds1.

I think you need to filter column E for "Does not begin with" RTS_
Then delete all the visible rows and remove the AutoFilter.
This can be done quickly and easily without a macro, but of course it could be done with code if needed.

 

[Distsyst]

I'm going to put this into action once I get to work today.
I really appreciate your time.

Thank you both so much!

 

[vds1]

I think you need to filter column E for "Does not begin with" RTS_

I think his data doesnt really begin with RTS_

Maybe you meant "does not contain".

 

[Peter_SSs]

I think his data doesnt really begin with RTS_

Maybe you meant "does not contain".

Possibly. The blue text could be interpreted two different ways:
a) The cells contain values like "RTS_11" somewhere within other text, or
b) The cells contain values exactly like the blue cells

I was swayed towards b) by the red text example.

Sample data:
*A****B****C****D****E*******F
4/23*james**1hr**r32**RTS_21***9
4/23**Leo***2hr**lpl***RPLN*****23


I am trying to keep all rows that have any of the following text in column E:
RTS_11
RTS_12
RTS_21
RTS_22
RTS_32
RTS_41
RTS_42
RTS_51
RTS_52