Convert geographical coordinates to degree

Hello members !
I have 2 columns of geographical coordinates in following format : Lat: 01 28 15 Long: 104 15 10
and I need to convert these 2 columns to degree : Lat: 1.47 Long: 104.25
I found this code from microsoft support page for the case that coordinates come with degree ° minute ' and second " signs. However, in my case, I don't have these signs.

Please Login or Register  to view this content.

Thank you

If your data are always in that format with spaces between numbers, try this:

Please Login or Register  to view this content.

That's right. Thank you StephenR.