'####################################################
'# Reza Kiani Moghaddam #
'# Convert Degree/Minute/Second to Decimal Degree #
'# TH 03/28/2013 14:32 #
'####################################################
Function ConvertToDecimalDegree(R As Range) As Double
Dim t As String
For Each cell In R
t = cell
Dim sp1 As Integer, sp2 As Integer
sp1 = InStr(1, t, " ")
sp2 = InStrRev(t, " ")
ConvertToDecimalDegree = CDbl(Replace(Mid(t, sp2 + 1), "°", "")) + _
CDbl(Replace(Mid(t, sp1 + 1, sp2 - sp1), "'", "")) / 60 + _
CDbl(Replace(Mid(t, 1, sp1), """", "")) / 3600
Next cell
End Function