Counting Elements in a String

[carl]

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.

 

[Frank Kabel]

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

 

[Leo Heuser]

One way:

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