Excel Filter

  KW2K 21:13 26 Aug 08
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 08
  KW2K 19:50 27 Aug 08

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

Regards.

  2neat 23:48 27 Aug 08

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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5