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.

count function
 

Hi,

Put these 3 formula ib B1, C1 & D1. Select all 3 and drag down

=IF(LEN(A1)=3,A1,"")
=IF(LEN(A1)=4,A1,"")
=IF(LEN(A1)=5,A1,"")

Mike


"monkeytrader" wrote:

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.

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.