Filtering by digits

C

cj21

I have a dataset of about 5000 rows, in it there are product codes o
varying length, i just want to filter the 4-digit numbers
Unfortunately the numbers are in text format because some begin wit
zero's. Anyone got any ideas?

Chri
 
D

Dave Peterson

I'd use a column of helper cells:

=--A2
and drag down.

Then filter by that column.
Custom|is greater than 999.

The -- converts the text numbers to number numbers.
 
Top