One way:
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"DD" wrote in message
...
If I enter the following into one cell what formula do I use so it recognize
it?
628.9,v14.0,v15.08
I want it to equal 3
|