Hi guys,
I've been at this all morning and had numerous attempts. Please help
Basically, in single cellsI receive data in this format:
25km 50m
3km 700m
.....
In order for me to do my relevant calculations, I need to split them into numbers only. For example:
kilometreage km m
25km 50m 25 50
3km 700m 3 700
Please see attached attempts for where I'm at.
Thanks i advance
JT