I import a file of Weights, Stones and Pounds always into column D2. They have to be imported from the Web as text and always have the (dash) as the Separator.
D2 9-7
D3 8-12
D4 8-11 etc down to D30.
Is there a Macro to convert these into just lbs leaving just this one number in the same Cell?
D2 133
D3 124
D4 123 etc
Thanks
D2 9-7
D3 8-12
D4 8-11 etc down to D30.
Is there a Macro to convert these into just lbs leaving just this one number in the same Cell?
D2 133
D3 124
D4 123 etc
Thanks