Extract the coordonates from Google Maps Link

**alexgoaga** · 07-04-2018, 04:41 AM

Hey guys, i'm having some problems extracting the coordonates from a tab link from google maps using vba function something like coordonate (link_from_cell_range,"X") , coordonate (link_from_cell_range,"Y")

Random location Example :
https://www.google.com/maps/@44.4299....066941,14.25z

i would like to have :
X = 44.4299073
y = 26.066941
z = 14.25 (not quite so important)

The problem is that i have links like this :
https://www.google.com/maps/place/Si...9!4d25.5623504

The new coordonates would be :
X = 45.3410878
y = 25.5164495
z = 13z (not quite so important)

I have an idea about how to extract all the numbers from the string but i can't figure it out how to take numbers specific by their location (variable link)

any ideas?

Thanks ,

Calin

**dflak** · 07-04-2018, 01:34 PM

I have two approaches to this issue. The first is a series of formulas as shown in column B of the attached workbook. These could be "rolled up" into three separate formulas but they would be very long and difficult to understand and debug.

The general approach is to use the find command to find the "@" symbol in the string, then find the subsequent "/" to "isolate" the coordinates (shown in cell B7). This string is further picked apart using commas as the separators.

The second approach is to use VBA and the split command to get the pieces in a User Defined Function: GetCoordinates("LinkString","Type") where Type is X, Y, or Z. (See Cells B17:B19).