Count instances of ; signs in a cell

Mr. Smith · Nov 27, 2003

(Thx A.W. J Ales for your VLOOKUP)

Hi

I have a cell that contains values like:
01,01;31.03;24.04;01.05

How could I count then number of ; (semicolons) in a cell?

Regards
Mr. Smith

Arvi Laanemets · Nov 27, 2003

Hi

With string in A1
=LEN(A1)-LEN(SUBSTITUTE(A1,";",""))

Mr. Smith · Nov 27, 2003

Thanks alot Arvi!!

Rgds
Mr. Smith

Arvi Laanemets said:
Hi

With string in A1
=LEN(A1)-LEN(SUBSTITUTE(A1,";",""))