Latitude & Longitude-Text Separation

I am using Excel to calculate distances from latitude and longitude GPS positions. These positions have a format as follows:


S36 39.113 E174 25.945


These have been imported into a column, and using VBA I wish to separate
latitude and longitude into two other columns. In both cases the minutes
will eventually have to be express as decimals of the degrees. I don't
mind if numerous columns are used as stages to get the final answer
which is 36.234678 in one column and 174.15567 in the other.

This can be done one bearing at a time or in a loop.

Thanks Sandy