Extract numbers in a cell ( in the middle )

	b	c
2	acw%
3	0-13-15	13%
4	0-27-11	27%
5	0-0-0	0%

	b	c
2	acw%
3	0-13-15	=(--substitute(mid(b3,search("-*?*-",b3),3),"-",""))/100
4	0-27-11	=(--substitute(mid(b4,search("-*?*-",b4),3),"-",""))/100
5	0-0-0	=(--substitute(mid(b5,search("-*?*-",b5),3),"-",""))/100

or if you predict middle number >99% (3 digits) use:

Formula:

=(--TRIM(MID(SUBSTITUTE(B3, "-", REPT(" ", 99)),100,99)))/100