Feb 14 2022 07:09 AM
what's the best way to change the packa weight in the far right column to just be a numerical value (i'm looking to convert to kilos)
Feb 14 2022 07:20 AM - edited Feb 14 2022 07:20 AM
Let's say the values are in D2 and down.
In another column, enter the following formula in row2, then fill down:
=IF(RIGHT(D2,2)=" G",--LEFT(D2,LEN(D2)-2)/1000,IF(RIGHT(D2,3)=" KG",--LEFT(D2,LEN(D2)-3),D2))