...
You could merge all the statements into one but for simplicity's sake I'm putting each step here:
In column C put the formula:
=MID(B1, 1, FIND("°", B1)-1)
In column D put the formula:
=MID(B1,FIND("°",B1)+1, ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.