Excel Filter

  KW2K 21:13 26 Aug 2008
Locked

Hi Everyone,
I have a spreadsheet with a list of user names in one column in the following format:
BloggsJ01
BloggsD02
BloggsF03
BrownA01
What I want to do is to remove all the names ending in 01. The spreadsheet has over 1200 usernames. Does anyone know how to filter them out.

Any help much appreciated.
Regards.

  2neat 05:30 27 Aug 2008
  KW2K 19:50 27 Aug 2008

Hi 2neat,
That's exactly what I was looking for, the tutorial is excellent !

Regards.

  2neat 23:48 27 Aug 2008

Glad it helped.
I regularly dip into click here when I get stuck or want to jaz it up ;-)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Comment afficher des fichiers cachés sur Mac ?