How to get latitude and longitude?

i have 2 fields hidden in my form and i want to add FORMULAs to save in my spreadsheet!

the formulas i want to use are:

=LEFT(B:B,FIND(",",B:B)-1)

and =RIGHT(B:B,FIND(",",B:B)-1)

but in my spreadsheet it saves

'=LEFT(B:B,FIND(",",B:B)-1)

'=RIGHT(B:B,FIND(",",B:B)-1)

add a ' that i don't want!

 is it possible to remove them?

Otherwise is it possible in anyway to split the values of the widget "Ubicazione GPS":Collect accurate GPS locations through your form in 2 values of the spreadsheet? 1 for lat and 1 for long?

i tryed to use the substring widget but i am not able to find the id of the locationgps that contain lat,lon 

Greetings and thank you for your message.

Unfortunately, it is not possible to remove the apostrophe when data is sent.

If you need to extract the latitude and longitude, you can use the Geolocation widget which will retrieve this information.

Please let us know if you have any additional questions.