Forum Discussion
Calculate total Dimensions
Hi, I wonder if someone can help me. I export a spreadsheet for work that has a column containing dimensions. While I'm at it, is there a way to calculate total weight as well? This one i normal...
Thank you both for these great responses.
I wasnt clear enough in my original post, but im also trying to work out how to calculate cubic meters for the 'dimensions' coloumn and then total that as well?
Is that possible?
I wasnt clear enough in my original post, but im also trying to work out how to calculate cubic meters for the 'dimensions' coloumn and then total that as well?
Is that possible?
JonesyT You could Text-to-columns from the Data ribbon to split the Dimension text string. Use space as the delimiter and you will end up with something like this:
Now you are all set to calculate volume from the numbers in columns with the numbers (in this case A, D and G).
Alternatively, go for a PowerQuery solution that you can use over and over again without having to split the dimensions column and enter formula and copy it down.
An example is included in the attached file.