Does anybody know of a quick and simple way to convert 19°02’00.2"N 72°50’24.0"E into Latitude Longitude coordinates which Glide understands?

[image] Manan_Mehta: 19°02’00.2"N 72°50’24.0"E If your format strictly follows this then the arrayformulas here will work. liquidacion dac fabiola App: Comments ID,Topic,Username,Email,Time,Comment 2m62FCts4yTZ4ziCBZqZ,We hope you will be able to join us in our app!,Thinh Dinh,ar…

Geocoding help needed

Ask for Help

Darren_Murphy November 18, 2020, 3:23pm 18

Okay, so I had to fix mine as well.

Now deals correctly with NSEW +/-
Converted to use ARRAYFORMULA

Google Sheet here

4 Likes

Topic		Replies	Views
API or script to convert DMS to DD Ask for Help	2	798	July 14, 2020
GPS, not avalaible / ne fonctionne pas Ask for Help	1	217	January 2, 2023
GPS Latitude Longitude concatenate Ask for Help custom-code	0	454	July 31, 2021
Formatting in Google Sheet for Long/Lat Coordinates? Ask for Help	7	4893	March 28, 2023
GPS DMS to Degrees Ask for Help custom-code	12	446	August 1, 2021

Geocoding help needed

Related topics