There are coordinates for the map, in one column is latitude, in the other is longitude, and in the third column there is a link to the map with coordinates. How to substitute in the link coordinates latitude and longitude in this link?

I tried to simply substitute = C5 in the link, but this does not work.

I tried in another way (maybe not quite normal), that is, from several columns to add a link, in one column start at the other end and insert longitude and latitude in the middle, but in this case an error comes out that you can only add digits in this way.

Example table https://docs.google.com/spreadsheets/d/1OzJIj4esFjT-Ng0KCgzvcvAXVdb6YxFpftbpXxid5eI/edit#gid=0

I thought it would be easy at first, but it turned out not. Tell me, please, the way.

    1 answer 1

    One way - you need to read about concatenation

    For example, on the first line in your file, the formula will look like this:

    =CONCATENATE(C2,A2,",",B2,D2)

    Taking into account the fact that in A2 - the first coordinate, in B2 - second, C2 - the first part of the link (before the coordinates), in D2 - the second part of the link (after the coordinates).

    • Sergey, thank you for the answer! - Sergey