Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting In a Cell
I have the following string in a cell. Each product is separated by a
semicolon. AG;AD;BG;FG;A1 Is there a formula that can tell me how many product are in the string. In this case the count would be 5. Thank you in advance. |
#2
|
|||
|
|||
Hi
=LEN(A1)-LEN(SUBSTITUTE(A1,";",""))+1 -- Regards Frank Kabel Frankfurt, Germany "carl" schrieb im Newsbeitrag ... I have the following string in a cell. Each product is separated by a semicolon. AG;AD;BG;FG;A1 Is there a formula that can tell me how many product are in the string. In this case the count would be 5. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting instances of words in a worksheet cell | Excel Discussion (Misc queries) | |||
Counting instances in a cell | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |