count numbers between dashes, keeping the dash

[Kmitchell]

Hello, having some difficulty with a formula that would allow me to count the numbers between each dash while preserving the dash

For example, all these NDCs have 10 digits. The below are an example of each scenario and the right post the equals sign is the desired answer

0002-0800-01 SHOULD EQUAL 4-4-2
50090-0353-0 SHOULD EQUAL 5-4-1

Columb B holds the NDC value

 

[Cubist]

Try:

Book1
	B	C
1	NDC	Length
2	0002-0800-01	4-4-2
3	50090-0353-0	5-4-1
Sheet6

Cell Formulas
Range	Formula
C2:C3	C2	=TEXTJOIN("-",,LEN(TEXTSPLIT(B2,"-")))

 

[Kmitchell]

Amazing, this worked perfectly, THANK YOU!