Forum Discussion
changing a number and letter combination to a calculated number (e.g. 500g to 0.1 Kg)
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)
1 Reply
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))
