Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count function | Excel Discussion (Misc queries) | |||
count function | Excel Worksheet Functions | |||
which count function? | Excel Discussion (Misc queries) | |||
which count function? | Excel Discussion (Misc queries) | |||
Count If Function | Excel Worksheet Functions |