Hi Excel Expert,

I have a list of values in column A of the form:
SF 17296CCH CALCIUM CHL 0.35KG 0.77LB
SF 17155MMA MALIC 5.442KG 11.998LB

in column B for the above examples I would like to get the KG values:
0.35
5.442

Can someone suggest an appropriate formula to achieve this from a range of similar data?

Thanks,
Hennerby