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

Nokia 8 vs Galaxy S8

Best new design books 2017: From vintage infographics to the the psychology of type

iMac 21.5-inch (2017) review

Nokia 8 : design, caractéristiques techniques, date de sortie