Hi Everyone
I have done a bit of VBA coding but usually it involves modifying existing code I have found on forums such as these - so I am at a fairly basic level.
In particular I have little to no experience in writing excel functions.
I am working with two different types of Google Map URL's where I need to extract the latitude and longitude in each case.
These are the two different "types" of Google Map URL's I am dealing with.
(1) 25°03'32.9"N 55°10'05.2"E
(2) 25°04'57.1"N 55°09'42.7"E · Dubai - United Arab Emirates
I need a two separate functions (or even one if its possible) to be able to extract the latitude and longitude in both cases.
I can use simple excel functions such as find, len, mid, etc and ask the specific questions of each URL to arrive at the right answer but it feels like a very rudimentary way to accomplish this task.
If anyone could help me either with a workable function or point me in the right direction it would be greatly appreciated.
I was only able to find a function that separated map URLs in this format (Google Maps) -- where it starts with an @ and is divided by comma's on this forum. I tried to rejig that function to deal with these other types of URL's but without success.
Any/all help appreciated for the project I am working on -- and to be able to understand and write excel functions.
Thank you.
I have done a bit of VBA coding but usually it involves modifying existing code I have found on forums such as these - so I am at a fairly basic level.
In particular I have little to no experience in writing excel functions.
I am working with two different types of Google Map URL's where I need to extract the latitude and longitude in each case.
These are the two different "types" of Google Map URL's I am dealing with.
(1) 25°03'32.9"N 55°10'05.2"E
(2) 25°04'57.1"N 55°09'42.7"E · Dubai - United Arab Emirates
I need a two separate functions (or even one if its possible) to be able to extract the latitude and longitude in both cases.
I can use simple excel functions such as find, len, mid, etc and ask the specific questions of each URL to arrive at the right answer but it feels like a very rudimentary way to accomplish this task.
If anyone could help me either with a workable function or point me in the right direction it would be greatly appreciated.
I was only able to find a function that separated map URLs in this format (Google Maps) -- where it starts with an @ and is divided by comma's on this forum. I tried to rejig that function to deal with these other types of URL's but without success.
Any/all help appreciated for the project I am working on -- and to be able to understand and write excel functions.
Thank you.
