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.
|