S
S
Sergey Kalinkin2018-04-23 03:27:44
Google Apps Script
Sergey Kalinkin, 2018-04-23 03:27:44

Google spreadsheets, how to make adding values ​​from multiple cells into one cell?

There are coordinates for the map, in one column latitude, in another longitude, and in the third column a link to the map that has the coordinates. How to substitute latitude and longitude coordinates into this link?
I tried just to substitute =C5 in the link, but it doesn't work.
I tried it in another way (maybe not quite normal), that is, add a link from several columns, in one column start to the other end and insert longitude and latitude in the middle, but in this case an error comes out that only numbers can be added in this way.
At first I thought it would be easy, but it turned out not to be. Please tell me the way.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Victor L, 2018-04-23
@atatat

=A2&B2&","&C2
5add97c772984170557231.png

A
alexalexes, 2018-04-23
@alexalexes

Glue (without []):

https://www.google.ru/maps/@[широта],[долгота],[масштаб]z

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question