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

--
Regards
Frank Kabel
Frankfurt, Germany

carl wrote:
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.