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