Count characters in a string

[jakobt]

I want to count in cell B1 how many times the character ";" exists in Cell A1
In cell C1 I want to calculate which number character the 2nd ; is positioned

Cell A1: yes;no;maybe;google;uk

 

[Rick Rothstein]

i want to count in cell b1 how many times the character ";" exists in cell a1

=len(a1)-len(substitute(a1,";",""))

in cell c1 i want to calculate which number character the 2nd ; is positioned

=find("|",substitute(a1,";","|",2))

 

[DanteAmor]

In cell C1 I want to calculate which number character the 2nd ; is positioned

Another option:

=FIND(";",A1,FIND(";",A1)+1)