Filter less than 5 characters

[Ravenous]

Hi All,
I am having trouble finding a VBA solution for what seems like it should be simple. I need to filter a column by all rows with a text string less than 5 characters (could be alpha, numeric or symbols).

I am able make this work to match 5 characters but not less than. What I have so far that doesn't work is below. Please help??

Please Login or Register  to view this content.

Thanks,
Brendan

[alansidman]

How about this

Please Login or Register  to view this content.

[Ravenous]

Thanks Alan,
It seems odd that this can't be done without a loop. Is this the case?

[davsth]

You could apply a conditional formatted based upon the length of the string. If you format the cells to a colour, you can filter for this colour. but again not a direct answer, but avoids a loop

[sintek]

Use a helper column with formula
Something like...

Please Login or Register  to view this content.

[Ravenous]

Thanks all,
I think the helper will be the fastest way to go. Cheers

[rorya]

You could use Criteria1:="<>?????*" but that will only work if your numbers are formatted as text. Actual numbers won't match any sort of wildcard.