You could even filter them and delete visible rows, no sort.
--
HTH
Bob Phillips
<Andy B wrote in message ...
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.)
|