Count instances of ; signs in a cell

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Count Number of Unique Cells That Don't Have Certain Characters 0
Split cells next to 1 cell 1
Return cell characters after space 2
Vlookup with part match 5
Counting unique instances of a text string 2
Is there a function to count how many times a cells value is used? 0
Move Chart with Text 0

Top