Calculate total Dimensions

Hi JonesyT 

There are different possibilities and I default to worksheet functions when reasonably possible;

Making the weights to number I'ld use 

=NUMBERVALUE(SUBSTITUTE(A2;" KG";"");".")

where substitute is to get rid of KG.

If you want to show the number as kilo, use NikolinoDE guide to format the numbers with trailing unit.

The volume is a longer formula. Cleans the data, make it look like HTML and parse it as XML to finally calculate the volume.

The LET function returns whatever is on the last line (I used alt+enter to make new lines).

You may test the different parts by changing the last output eg to data or dataArrayNum 

=LET(range;C2;
data;SUBSTITUTE(range;" CM";"");
data_as_html;"<tr><td>" & SUBSTITUTE(data;" X ";"</td><td>") & "</td></tr>";
dataArrayText;transpose(FILTERXML(data_as_html;"//td"));
dataArrayNum;NUMBERVALUE(dataArrayText;".");
output;PRODUCT(dataArrayNum);
output
)