Custom Filter for Number Pattern

penheadnc

New Member
Joined
Apr 16, 2010
Messages
2
I have data similar to below
17120141548
58820136814
31220146235
18020148742
91020137421

I want to use the custom filter to identify only those cells in which the 6th and 7th digit is 14.

I've tried every combination I can and can't make it work.
I've chosen "contains" *****14**** and ?????14???? and both yield no results.

TIA!
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

VBA Geek

MrExcel MVP
Joined
Dec 16, 2013
Messages
2,857
you may use a helper column in which you would this formula

=--MID(A2,6,2)=14

then filter by TRUE

or conditional format with the same formula and then filter by color
 

Watch MrExcel Video

Forum statistics

Threads
1,109,466
Messages
5,528,972
Members
409,848
Latest member
Blomsten
Top