# Incorrect text extraction from geocoding with Google Sheet

**URL:** https://community.glideapps.com/t/incorrect-text-extraction-from-geocoding-with-google-sheet/41180
**Category:** Ask for Help
**Created:** [April 24, 2022, 12:56pm UTC](https://community.glideapps.com/t/incorrect-text-extraction-from-geocoding-with-google-sheet/41180 "2022-04-24T12:56:16Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![profxeni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profxeni/32/24656_2.png) [@profxeni](https://community.glideapps.com/u/profxeni)
#### Post date: [April 24, 2022, 12:56pm UTC](https://community.glideapps.com/t/incorrect-text-extraction-from-geocoding-with-google-sheet/41180/1 "2022-04-24T12:56:16Z")

</div>

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?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/986531c9f458aa70b01ef15bf20d120bd8792052.png)

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [April 24, 2022, 2:51pm UTC](https://community.glideapps.com/t/incorrect-text-extraction-from-geocoding-with-google-sheet/41180/2 "2022-04-24T14:51:46Z")

</div>

Hola!

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.

Saludos!