View Single Post
  #1   Report Post  
monkeytrader
 
Posts: n/a
Default how do i filter data by number of characters in excel?

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...