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

 

[smozgur]

I would assume you needed a formula, but your attachment is not accessible.
If you'd like to answer your own question, it is perfectly fine to mark it as the solution. However, it would be more helpful to future readers if you could reveal the formula in E2.
Therefore, I removed the solution mark in your post.