Need GPS Coordinate Sequence

[rebel123]

Need GPS Coordinate Sequence in pull-down formula. Correct answers are in yellow-

https://docs.google.com/spreadsheets/d/1sQ1sopBb13NyakB3du7zGW1DxhB-3zdT/

 

[rebel123]

The correct answer would have an =D2 beginning I would assume?

I copied and pasted it but it did no format correctly. Here it is but it should not show the degrees in the "Actual Map" and it should look like the image.

Listing #	Stop #	Address	GPS Coordinates	Actual Map
n7	1​	Port Rd, Pine Bluff, AR 71601, USA	34.2291364, -91.978581	34°13'44.9"N 91°58'42.9"W
f5	2​	N Oregon St, Pine Bluff, AR 71601, USA	34.229525, -91.979172	34°13'46.3"N 91°58'45.0"W