Count the number of Times a character is in a cell

[gheyman]

I have a column that has Numbering - WBS Numbering to be exact
1.00
1.00.01
1.00.01.01
1.00.01.02
1.00.01.03
1.01
1.01.01


I need a formula that I can run down the next column to count how many "." are in each

1.00 1
1.00.01 2
1.00.01.01 3
1.00.01.02 3
1.01 1


Is this possible?

 

[JoeMo]

Excel Workbook
	A	B
1	1	0
2	1.00.01	2
3	1.00.01.01	3
4	1.00.01.02	3
5	1.00.01.03	3
6	1.01	1
7	1.01.01	2
Sheet4

 

[gheyman]

Thanks! very much appreciated. exactly what I needed

 

[JoeMo]

Thanks! very much appreciated. exactly what I needed

You are welcome - thanks for the reply.