GPS and Maidenhead gridsquare conversions for Excel into Latitude and Longitude (decimal)
=(CODE(MID(A2,2,1))-65)*10 + VALUE(MID(A2,4,1)) + (CODE(MID(A2,6,1))-97)/24 + 1/48 - 90
=(CODE(MID(A2,1,1))-65)*20 + VALUE(MID(A2,3,1))*2 + (CODE(MID(A2,5,1))-97)/12 + 1/24 - 180
presumes 6-character gridsquare address stored in column A.
Case-sensitive, 2 UPPERCASE letters, 2 numbers 2 lowercase.
first formula provides latitude.
second line provides the longitude.
(+/- decimal)