changing a number and letter combination to a calculated number (e.g. 500g to 0.1 Kg)

Copper Contributor

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) 

cmckernan93_0-1644850077033.png

 

1 Reply

@cmckernan93 

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))