Hi
Without using a macro you could do this job with a helper column alongside
your data. Put something like this:
=COUNTIF(A2:A25,"0000")=0
You can then fill this down. To fix the values in place, copy the range and
Edit|Paste Special|Values. You can now sort on this column and delete all
the TRUE rows.

--
Andy.


"CJSnet" wrote in message
...
Hi, I've exported a CSV list of phone calls from Skype into Excel. I want
to delete all rows that do not contain a certain number string e.g. 0000.
Is this possible?

Ideally it would move other rows up to fill the gaps so I'm just left with
a neat list of remaining numbers.
--
Thanks.

CJSnet

(Remove TEETH to reply by e-mail.)