software

Hi,

I have a spreadsheet that looks something like this

A B C
D E F

52228752708HNLSFOORDMANG7849NAUKXGA
52228975798HNLSFODENMANG7899NAUKXGB
52228975818HNLSFOORDMANG7899NAUKXGB
52563110739IADJFKEWRCHIMANH5825CSUKXGA
52563110759IADJFKEWRORDMANH5825CSUKXGA
52563110779IADJFKEWRJFKMANH5825CSUKXGA
52534398237IADORDMANQ5927TXUKXGB
52534398257IADORDMANQ5927TXUKXGB

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.

JohnOne approach would be to use in unused column with the formula:
=IF(ISERROR(FIND(quot;ordquot;,C2)),quot;Not Foundquot;,quot;quot;)

as this will evaulate the string C2, if it finds quot;ORDquot; anywhere, the result
will be null quot;quot;, if it doesn't find it the result will be quot;Not Foundquot;. Next,
sort the data by this temporary column and then delete all the rows with
quot;Not Foundquot; listed in that column.quot;mg_sv_rquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have a spreadsheet that looks something like this
gt;
gt; A B C
gt; D E F
gt;
gt; 5222875270 8 HNLSFOORDMAN G7849NA UK XGA
gt; 5222897579 8 HNLSFODENMAN G7899NA UK XGB
gt; 5222897581 8 HNLSFOORDMAN G7899NA UK XGB
gt; 5256311073 9 IADJFKEWRCHIMAN H5825CS UK XGA
gt; 5256311075 9 IADJFKEWRORDMAN H5825CS UK XGA
gt; 5256311077 9 IADJFKEWRJFKMAN H5825CS UK XGA
gt; 5253439823 7 IADORDMAN Q5927TX UK XGB
gt; 5253439825 7 IADORDMAN Q5927TX UK XGB
gt;
gt; Only mine is about 40,000 rows! Now I want to strip out of that worksheet
gt; any rows where column C does not contain the letters ORD anywhere in the
gt; string. Is there a way of doing this without manually going through it? I
gt; just need the rows deleted, they do not need keeping for any purpose.
gt;
gt; Thanks in advance for any help.
gt;
gt; John
gt;You may use a formula like this in an additional column (G, for example)
=ISNUMBER(FIND(quot;ORDquot;,C1))
Then copy the formula all along the range, sort on that column and delete
all the rows that have FALSE on it.

Hope this helps,
Miguel.

quot;mg_sv_rquot; wrote:

gt; Hi,
gt;
gt; I have a spreadsheet that looks something like this
gt;
gt; A B C
gt; D E F
gt;
gt; 52228752708HNLSFOORDMANG7849NAUKXGA
gt; 52228975798HNLSFODENMANG7899NAUKXGB
gt; 52228975818HNLSFOORDMANG7899NAUKXGB
gt; 52563110739IADJFKEWRCHIMANH5825CSUKXGA
gt; 52563110759IADJFKEWRORDMANH5825CSUKXGA
gt; 52563110779IADJFKEWRJFKMANH5825CSUKXGA
gt; 52534398237IADORDMANQ5927TXUKXGB
gt; 52534398257IADORDMANQ5927TXUKXGB
gt;
gt; Only mine is about 40,000 rows! Now I want to strip out of that worksheet
gt; any rows where column C does not contain the letters ORD anywhere in the
gt; string. Is there a way of doing this without manually going through it? I
gt; just need the rows deleted, they do not need keeping for any purpose.
gt;
gt; Thanks in advance for any help.
gt;
gt; John
gt;