Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have different multiples of 4 character strings delimited by commas in a
column of cells. I just need to count the commas so I can have the number of multiples of 4 strings. For example, I could have ABCD, in cell one. In cell 2 I could have ABCD,EFGH, in the next cell. In cell 3 I could have ABCD,EFGH,IJKL, I don't know what the string functions would be. But I need to count those groupings of 4 characters. Something like this? count( left(4,",")) thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to add commas to the result of a formula with a text operator? | Excel Discussion (Misc queries) | |||
So many commas | Excel Worksheet Functions | |||
Count values between commas | Excel Discussion (Misc queries) | |||
Count Commas in Cells | Excel Discussion (Misc queries) | |||
Removing commas | Excel Worksheet Functions |