The incoming Data is always inserted into column D
EG 1m 12.66s
2m 23.44s
1m 35.32s
I want to be able to convert these times to :
72.66
143.44
95.32
with no text, no spaces but keeping the decimal point so that I can calculate. You will notice that there is a space on the original Data between the "m" and the next number.
Macro would be helpful
Thank you.
EG 1m 12.66s
2m 23.44s
1m 35.32s
I want to be able to convert these times to :
72.66
143.44
95.32
with no text, no spaces but keeping the decimal point so that I can calculate. You will notice that there is a space on the original Data between the "m" and the next number.
Macro would be helpful
Thank you.