Sending Lat Long via SMS

[nando9]

I'm trying to send Lat/Long coordinates via SMS. I would like to the recipient to click on a hyperlink that would give directions to the coordinates. I'm able to create the link as "https://www.google.com/maps/search/?api=1&query= latitude, longitude" the only problem is when the hyperlink is received the longitude is not included in the hyperlink because of the comma.

Does anyone know of a workaround for this?

[Joseph_Seddik · Accepted solution]

Remove the spaces and just replace the comma by "%2C", or use: 

ENCODEURL() | AppSheet Help Center 

[nando9]

ENCODEURL() worked. Thank you very much.