Convert Geo Coordinates to Decimal

[DJFANDANGO]

Hey Team,

I have a datasheet of Geo locations that are all mixed up in different formats etc in 'Information Provided', whats the easiest way to clean these all up and have them presented in decimal form (like they are at the bottom of the list in 'Results Needed')?

See my data sheet below... Many thanks for your help.

Geo Data.xlsx
	A	B	C	D	E
1	Information Provided			Result Needed
2	Latitude	Longitude		Latitude	Longitude
3	13° 54 ‘	18° 7’ 25” W
4	14° 45 ‘23” N	18° 48’ 28” W
5		NA
6		NA
7		24°48,9 N - 054° 22,4 E
8		24°31.2088N 052°07.1537E
9		24°29.114N 051°35.101E
10		NA
11		NA
12		24°30.696N 051°41.825E
13		NA
14		24* 52, 5 N - 054* 05, 3 E
15		24°50.40′N，054°17.30′E
16		24°53.73'N 054 39.26'E
17		25°05640296‘N/ 52°40324541’E
18		25°03′10.0452″/53°03′01.5697″
19		25°28.93‘N/ 052°41.07’E
20		24°29'37.26"N/51°44'14.07"E
21		24°30'15.27"N/51°51'58.73"E
22		24°53.5'N 054°28.9'E
23		24°47.418'N 53° 04.136'E
24		24o 49.34'N/52o 55.55'E
25		24°22.104/51°42.618
26		24°40.58'N; 053° 40.62'E
27		25°26′45.66″N 53°38′11.38″E
28		25°25.832N 53°40.282E
29		24°53.73'N 054 39.26'E
30		25°05640296‘N/ 52°40324541’E
31		25°03′10.0452″/53°03′01.5697″
32		25°28.93‘N/ 052°41.07’E
33		24°29'37.26"N/51°44'14.07"E
34		24°30'15.27"N/51°51'58.73"E
35		24°53.5'N 054°28.9'E
36		24°47.418'N 53° 04.136'E
37		24o 49.34'N/52o 55.55'E
38		24°22.104/51°42.618
39		24°40.58'N; 053° 40.62'E
40		25°26′45.66″N 53°38′11.38″E
41		25°25.832N 53°40.282E
42		25 22.7660 N 053 42.7052 E
43		24°19'62"N/52°02'12"E
44		NA
45		NA
46		24°19'62"N/52°02'12"E
47		NA
48		NA
49		NA
50		NA
51		25 33.3657 N 053 48.7357 E
52		NA
53		25 32.5666 N 053 48.5251 E
54		Latitude: 24°32′.226″ Longitude: 53°43′.009″
55		Latitude: 25°06′38.0022″ Longitude: 53°04′38.9432″
56		24 40.700 N 53 24. 100 E
57		25°25′13.1″N 53°49′27.1″E
58		25°23′16.7″N 53°59′26.8″E
59		NA
60		Lat: 52° 37,´6 S Lon: 063° 17,'8 W
61		NA
62		25°25′27″N 54°01′47″E
63		NA
64		Freeport
65		25°26′36.7″N 54°11′27.8″E
66		NA
67		NA
68		NA
69		NA
70		NA
71		24-45.68 N / 053-56.83 E
72		NA
73		NA
74		53°52.4369' 23°37.4912'
75		24°05.601N/51°51.132E
76		24°08'8084"N/52°06'0765"E
77		NA
78		24°05.285N /51°56.868 E
79		NA
80		NA
81		NA
82		NA
83		NA
84		25°20,641 N/54°1,777 'E
85		NA
86		25. 203N, 054.005E
87		24°16.008N /52°09.090 E
88		NA
89		24°10.9718N /51°79.540 E
90		No provided
91		24°11.0133N /51°79.76 E
92		NA
93		24°11.0133N /51°79.76 E
94		NA
95		28º44.46S 045º37.79W
96		24°09.410N /51°51.581 E
97		25. 19‘22N, 53.51’15E
98		24°07.904 N /51°49.277 E
99		24°06.531 N /51°51.871 E
100		24°42′39.9093″ 053°10′32.4168″
101		29°00′18″S / 047°18′36″W
102		29º14.60 S
103		25. 20‘37N, 53.40’54E
104		24°41′27.164″ 053°22′38.383″
105		25. 17‘345N, 53.40’046E
106		27º52.60 S 046º44.0W
107		24°47.80″ 053°14.94″
108		24°49.740″ 053°15.741″
109		24°50′12.2536″ 053°16′51.2251″
110		24°50′12.7556″ 053°15′50.8433″
111		25. 16‘866N, 53.52’479E
112		24°54′37.6362″N / 53°14′33.8614″E
113		24°55′06.6639″ / 053°14′32.6962″
114		30º02.28 S 047º58.86W
115		NA
116		25. 18‘872N, 54.08’294E
117		25°00′24.363″ / 053°19′25.176″
118		24°59′25.3442″ / 053°14′42.8127″
119		25. 12‘593N, 54.19’676E
120		24°49′10.6659″ 053°21′36.6171″
121		25°17.575852N.54°16.773422E
122		24°38′98″N/53°23′82″E
123		25°18.34N 54°20.01E
124		24°29.1735 N / 54°05.7372 E
125		2.54624, 7.43915
126		25°07.19N 54°38.31E
127		24°59′24.6606″ 054°47′49.4249″
128		24'26.265 N 053'52.686 E
129		02-12.7N, 006-25.0E
130		02-20,3N, 006-57,0E
131		25.09.240N 054.34.760E
132		2o14.26'N 7o15.61'E
133		GPS 02-31,6N, 007-25,7E
134		Latitude: 25°03′44.5859″ Longitude: 054°38′30.1805″
135		27º41.88 S 045º48.24W
136		Latitude: 24°59′54.8678″ Longitude: 054°33′02.9310″
137		25°00.131 054°25.517
138		25°03.366N 54°25.064E
139		25°05.855N 54°22.631E
140		02 degrees 11.2' N 008 degrees 31.80.31" E
141		02 degrees 18'08.02" N 007 degrees 23'40.31" E
142		Lat: 24*27.04'N Long:053*36.25'E
143		Lat: 24*18.01'N Long:053*33.40'E
144		L: 02°15.20’N, Long: 006°50.85’E
145		Lat: 02°21.5’N, Long: 006°18.4’E
146		Lat 02-18012N Long -006-05.89E
147		Lat 02-09.14N Long -006-31.34E
148		Lat 02-01.18N Long -006-17.69E
149		NA
150		01-56.16N Long 006-14.90E
151		02°53.1’N, 006°57.9’E
152		27°72′25.25.5″ 080°92′65.5″
153		– 02-42.7N 006-22.79E
154		17°25'41.2N / 18°34'22.5W
155		20°30'15.46N / 20°07'19.32W
156		18° 30,4'N / 19° 22,5'W
157		19°22'15.0N / 19°54'04.0W
158		Higher Yasat Island
159		16°49'46.5N / 17°08'28.6W
160		20°18'3N / 19°26'7W
161		053°56.17596′E 25°11.61497′N
162		25°17.58′N 53°29.08′E
163		25°06.38′N 53°41.85′E
164		25° 04.5′ N 53° 57.4′ E
165		24° 52.3084′ N 053° 53.9305′ E
166		19°37'11.35N / 19°33'46.61W
167		24°01.58N 53°52.25E
168		24* 19.76'N 053* 53.40'E
169		24* 11.92'N 051* 57.73'E
170		19°14'46.7N / 19°47'44.4W
171		19°18.3‘N / 20°07.8’W
172		24* 12.01'N 052* 03.27'E
173		NA
174		06° 37,´27 056° 32,'35
175		24°59.39′N 53°43.14′E
176		25°10′25.42″N 53°43′12.03″E
177		18°59.0‘N / 18°39.4’W
178		25° 13 ‘22 ” N / 53° 38’ 16” W
179		18°17.1‘N / 19°1.4’W
180		25°09 37.46N 53°37 49.25E
181		25°01. 57N 53°37.115E
182		25°02. 54N 53°36.875E
183		53° 39.038′ E 25° 06.071′ N
184		Lat: 06° 43' 20 Lon: 056° 25' 20
185		25°12′36.00″N 53°37′43.00″E
186		25°00′48.00″N 53°37′27.01″E
187		24°59.18N 53°35.63E
188		NA
189		06'29.944' N 056'14.137'W
190		24°59.1′N 53°32.8′E
191		24°58.9′N 53°33.7′E
192		06° 35,´14N 056° 12,'00W
193		Lat: 06° 57' Lon: 056° 22'
194		25°00′31.67″N 53°17′40.72″E
195		06° 57' 056° 25'
196		25°00′47.99″N 53°18′33.85″E
197		24°59′56.21″N 53°18′32.61″E
198		NA
199		06 53.2N 056 83.6W
200		24°55.84′N 53°24.97′E
201		56.7°W, 007.4°N
202		25°01′37.15″N 53°23′24.03″E
203		24°58′58.18″N 53°23′42.66″E
204		25°01′34.18″N 53°23′55.51″E
205		25°00′29.41″N 53°25′51.81″E
206		25°01′15.20″N 53°26′9.02″E
207		24 23.43 N - 053 45.56 E
208		24 28.487 N - 053 47.185 E
209		24 28.487 N - 053 47.185 E
210		24°59′30.16″N 53°26′54.61″E
211		24°57.4N53°27.2E
212		06°43.4N - 056°22.4W
213		25°1′40.62″N 53°28′39.38″E
214		08°8'9''N - 56°21'7''W
215		24’25,740'N 053’35,530E
216		25°01′13.12″N 53°30′15.31″E
217		6°42.35'N - 55° 01.65'W
218		31°27'06'' S/ 015°30'43''E
219		2425873N 54363067E
220		7°13.6'N - 56° 10.2'W
221		25°00′12.71″N 53°33′36.04″E
222		2425365
223		24°59′59.38″N 53°42′46.41″E
224		24°58′12.04″N 53°34′39.15″E
225		24°59′18.53″N 53°41′43.95″E
226		24 56.711N，053 45.06E
227		24°56.38N53°41.29E
228		06° 43,´0 N 056° 16,'9W
229		06° 39,´1N 055° 50,'9W
230		2424167N 5429712E
231		06'29.944' N 056'14.137'W
232		06°42'N 055°45'W
233		2426185 N 5419317W
234		25°00.21N 53°45.23E
235		N 24 20.2850 E 054 10.7862
236		06°75'N 055°90'W
237		07°26'N 055°35'W
238		06° 38.0’ N 055° 47.9’ W
239		6° 30' 00 N 54° 41' 39" W
240		06° 35.0’ N 054° 44.9’ W
241		06° 27.8’ N 056° 01.4’ W
242		06° 33.9’ N 055° 27.3’ W
243		06° 28.80' N 056° 24.75' W
244		24°59.39N 053°23.36E
245				24.343	53.144
246		06° 25.6' N 054° 58.7' W
247		24'10.742' N 053'23.313' E
248		24'09.24' N 052'25.07' E
249		06° 33.11 N 055° 47.17 W
250		06-31.8N; 055-48.8W
251		24.823075 53.492627
252		06° 26.0 N 054° 49.06 W
253		06° 26.0 N 055° 00.0 W
254				24.159722	54.071667
255		06° 26.11 N 056° 20.15 W
256		06° 30.1 N 055° 12.9 W
257		06° 25 N 055° 47.7 W
258		06°33.5N 55°32.3W
259		06°28.9N 55°34.2W
260				24.2	52.47
261	06°31.3N	56°02.2W
262	06°56.4N	56°38.3W
263	06°56.5N	55°42W
264	06°56.7N	56°40.7W
265	06°50.8N	056°05.8W
266	06°56.1N	055°40.0W
267	06°52.8N	056°46.0W
268	06°56.3N	56°48.6W
269	06°49.6N	55°49W
270	06°55.3N	55°38.1W
271	06°51.3N	55°39.6W
272	06°59.5N	56°15.2W
273	06°59.1N	56°04.4W
274	06°59.1N	56°31.2W
275	07°46.7N	57°20.4W
276	08°37.5N	58°11.4W
277	08°54.6N	58°28.9W
278	08°58.5N	58°32.6W
279				7.943	-57.3683
280				6.41	-56.685
281				6.393	-56.1816
282				6.426	-56.67
283				6.356	-56.7708
284				6.4	-55.7428
285				6.316	-56.91516
286				6.308	-55.8935
287				6.37	-56.73
288	24 42.32	53 44.13
289	24°47.459N	53°21.128E
290				24.341155	54.199928
Data