Product Master by sku.xls | ||||||
---|---|---|---|---|---|---|
E | F | G | H | |||
1 | 6'4" | |||||
2 | 5'9" | |||||
3 | 6'2" | |||||
4 | ||||||
5 | 18'3" | |||||
6 | ||||||
Sheet3 |
=INT((SUM(VALUE(LEFT(E1:E3,FIND("'",E1:E3,1)-1)))*12+SUM(VALUE(MID(E1:E3,FIND("'",E1:E3,1)+1,LEN(E1:E3)-FIND("'",E1:E3,1)-1))))/12)&"'"&MOD(SUM(VALUE(LEFT(E1:E3,FIND("'",E1:E3,1)-1)))*12+SUM(VALUE(MID(E1:E3,FIND("'",E1:E3,1)+1,LEN(E1:E3)-FIND("'",E1:E3,1)-1))),12)&""""