ExcelBanter - Counting In a Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting In a Cell (https://www.excelbanter.com/excel-worksheet-functions/7189-counting-cell.html)

carl

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.

Frank Kabel

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.

All times are GMT +1. The time now is 11:02 PM.