Thread: count function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
monkeytrader monkeytrader is offline
external usenet poster
 
Posts: 16
Default count function

i have a column of 3, 4, and 5 letter symbols and want to separate the data
according to numbers of letters.

ex:
abc
abcde
abcd
def
defg
ghi
ghikl

want to know if column b can show only 3 letter symbols, column c show 4
letter symbols, etc.

thanks in advance for your help.