Delete cells if contain various strings of text & move cells up

[waldz]

Hi so I'd like some help with something I am currently working on.

I need to delete all values that contain IA, IB, JC etc the cells will have "IA01" "IA02" etc

I'd like to delete these values and move the cells up all using a formula if possible - although VBA/macro is also ok

These are bulk stock locations and are not to be included in an empty space finder in our warehouse.