count function
In B
=IF(LEN(A2)=3,A2,"")
copy down
do the same for C and D and change the number after the LEN part to 4 and 5
for those
columns
--
Regards,
Peo Sjoblom
"monkeytrader" wrote in message
...
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.
|