Count instances of ; signs in a cell

  • Thread starter Thread starter Mr. Smith
  • Start date Start date
M

Mr. Smith

(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
 
Back
Top