One way:

=LEN(A1)-LEN(SUBSTITUTE(A1,";",""))+1

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"carl" skrev i en meddelelse
...
I have strings like these:

AB;CD;EF;GH;IJ

Is there an easy way to count the number of elements in the string. In
this
case the count would be 5.

Thank you in advance.