how do i filter data by number of characters in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of symbols that are either 3, 4, or 5 characters in length and
wanted to filter them so the output consists only of those that are 3
characters in length.

ex)

A B C
1 aaa
2 bbbb
3 ccc
4 ddddd

How would I make a list in column "B" with only those symbols that are
3-characters in lenght from column "A"?

Thanks for your help in advance...
 
Note that if you wish, you can autofilter them in place. Select Custom
from the autofilter dropdown and set the criterion to

equals ???
 
Back
Top