If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|