Hi,

I have a spreadsheet that looks something like this

A B C
D E F

5222875270 8 HNLSFOORDMAN G7849NA UK XGA
5222897579 8 HNLSFODENMAN G7899NA UK XGB
5222897581 8 HNLSFOORDMAN G7899NA UK XGB
5256311073 9 IADJFKEWRCHIMAN H5825CS UK XGA
5256311075 9 IADJFKEWRORDMAN H5825CS UK XGA
5256311077 9 IADJFKEWRJFKMAN H5825CS UK XGA
5253439823 7 IADORDMAN Q5927TX UK XGB
5253439825 7 IADORDMAN Q5927TX UK XGB

Only mine is about 40,000 rows! Now I want to strip out of that worksheet
any rows where column C does not contain the letters ORD anywhere in the
string. Is there a way of doing this without manually going through it? I
just need the rows deleted, they do not need keeping for any purpose.

Thanks in advance for any help.

John