Incorrect text extraction from geocoding with Google Sheet

Greetings to all. I don’t know if it happened to any of you too, an operation on a sheet cell representing a geocoding, which changes when latitude and longitude are extracted. If you execute it from Glide with Split… blah blah blah, it works, but if I try with Google Sheet, the SPLIT function works, but the extraction on the two columns is not what I expect. Edit everything. Any ideas to not go crazy?


If I could follow you, It looks like a problem with numeric format you are using (regional settings).

Maybe a comma (‘,’) is driving you crazy when it is used as thousands separator in your coordinates.


1 Like