Automate GPS coordinates from Google maps pasting into 2 adjacent cells.

**blancpain** · 08-25-2022, 07:23 AM

Hi,

I have a sheet that requires the input of a latitude and longitude into adjacent cells.

I would like to be able to right-click on a Google map to get the coordinates and then paste directly into the cells with the coordinates being split into the seperate cells.

I find that the coordinates end up pasting into 1 cell and then I have to manually use the text to columns to split the data.

So, when I right-click and paste into the Latitude cell it comes out like this
bad text to columns.png

I would like it to automatically come out like this.
good text to columns.png

Thanks in advance for any help

**AliGW** · 08-25-2022, 07:30 AM

Welcome to the forum.

There is nothing you can do about the way that the data is copied to your clipboard, but if you are prepared to have a data dump somewhere in your workbook, you can set up a formula to pull the lattitude and longitude values separately into two columns.

Provide a sample data dump in a workbook if you'd like to pursue this option.

**blancpain** · 08-26-2022, 12:15 AM

Ok, I wondered if that was the case.

I can semi-automate via a power query which may be my tidiest option.

Thanks

**AliGW** · 08-26-2022, 02:07 AM

Yes, that's one simple way.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

**swaatacba** · 08-26-2022, 03:38 AM

Another work around is to import the latitude and longitude reference as a string. Then split it by finding the position of ", " and extracting the references using =MID(GridRef, Before ", ", Len) and =MID(GridRef, After", ", Len).

I attach an example workbook.