Forum Discussion
JonesyT
Sep 28, 2021Copper Contributor
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...
Riny_van_Eekelen
Sep 28, 2021Platinum Contributor
JonesyT You could use Find & Replace to get rid of the " KG" part
Select the column(s) with the weights in them. Ctrl-H to open the Find & Replace window. Type " KG" (i.e. a space and capital K and G) in the Find field. Leave the Replace field blank. Replace All and close the window. Now you should be left with numbers that you can calculate with.