How To exclude a specific list of number at a specific position

Question

I have a list of numbers and I would like to remove every numbers that are different that the number I want to keep for eg that's the list:

01 54 88  <== remove
09 52 55  <== remove 
08 55 67
00 66 22  <== remove
04 44 11  <== remove
04 52 74  <== remove
02 98 65  <== remove
05 55 33

So here I remove every number different than "55" at position 4 So I keep:

08 55 67
05 55 33

these two numbers

Is it possible to do that with Excel ?

Note: I have an KuTools for Excel if necessary.

Thanks for help in advance and sorry for my english :)

Answer 1

You can use a simple filter with

text equals:  ???55???

BEFORE

AFTER