ExcelBanter - how to filter by the first digit of list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to filter by the first digit of list (https://www.excelbanter.com/excel-discussion-misc-queries/249893-how-filter-first-digit-list.html)

how to filter by the first digit of list

Hi,
I have the following 2 columns
ID Text
1000 abc
1001 def
1002 €¦€¦
1003
1004
2000
2001
2002
3000
3001
What I want to do is filtering the list by using for example the first 3 digit
For example, I want to filter by using 1000 and its sequence numbers 1001,
1002€¦..
How to do that

how to filter by the first digit of list

Jon -

If you are using AutoFilter, you can use the the Custom option. If your ID
field is text, use the 'Starts With' and the numbers you want to start with
(e.g. 100). If your ID field is numeric, then use 'Greater Than Or Equal To'
and 1000, then click the AND button, and use 'Less Than' and 2000.

--
Daryl S

"Jon" wrote:

Hi,
I have the following 2 columns
ID Text
1000 abc
1001 def
1002 €¦€¦
1003
1004
2000
2001
2002
3000
3001
What I want to do is filtering the list by using for example the first 3 digit
For example, I want to filter by using 1000 and its sequence numbers 1001,
1002€¦..
How to do that