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

I would employ an Advanced Filter using:

=LEN(A2)=3

for the criteria. To use an Advanced Filter, check out:

http://www.contextures.com/xladvfilter01.html

HTH
Jason
Atlanta, GA

-----Original Message-----
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 ???


In article ,
monkeytrader wrote:

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