Delete / Keep rows containing specific text.

Hello

I need some help to remove/keep rows from a large spreadsheet. I think the easiest way would be to specify the text in the row I want to keep.
The text which requires sorting is in one column A: and looks like this -

ARM0009
ARM0041
BOR0024
BOR0035
CEN0029
CHS0003

for the above I would like to retain rows which contain BOR and CEN and delete all the others.

I have tried numerous macros but being new to it I'm struggling to get anything to work.

Any help would be much appreciated.

Thanks