View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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