Filter by len

[fairyme]

I want to filter column A that len = 8

Now I use code as below.

Please Login or Register  to view this content.

but output incorrect.

Please guide me for solve it.

Thank you

[FDibbins]

Why dont you just use a helper column that will ID len = 8, then filter on that?

=LEN(A2)=8 will give a TRUE or FALSE answer - filter on TRUE

[leelnich]

Your workbook doesn't include any rows you want to filter out, so how can we test? We don't know what we have to eliminate.
Is this the only filtered column?