1. S

    Working with GPS position/coordinate formates

    Hi, I am working on a data set which manages positions for landing sites. I need to be able to format positions in 2 different ways, one as Degrees Decimal Minutes (including symbols), and the other as Decimal degrees (+ and - based on E/W). The positions are entered in an info sheet for each...
  2. N

    Verifying Longitude and Latitude

    I am trying to find or create a formula to compare to make sure that executed and completed, latitude and longitudes are a close match to the store longitude and latitudes closely match. I am thinking maybe a formula that will highlight the executed and completed coordinates green for close and...
  3. S

    Converting into gps coordinates

    Dear forum. I have made an Excel sheet, where I entered (copy-pasted) gps coordinates from Google Maps. The column settings in Excel were not adjusted from the beginning, because I couldn't seem to find the right setting. This means that the current format is e.g. 55.419.474 10.455.039 and...
  4. F

    Generating Google Maps URL with GPS Coordinates from sheet cells and Displaying Complete URL in a cell

    Hi I have a worksheet that lists physical locations and 2 respective columns that display the latitude and longitude coordinates for the location in that row. I am trying to automatically generate a respective URL in the cell adjacent to the coordinates columns that displays the complete URL...
  5. O

    GPS Coordinates

    Hi Dear Friends, Does anybody know how I can use VBA to get the coordinates of a point using a GPS or a Satellite? If Access/Excel cannot do this on their own, probably there is an ActiveX control somewhere that can be plugged in? Thanks in advance Sam
  6. L

    How to connect gps coordinates with location names and associated data

    Hi all, I have just entered into the 5th year of a predator trapping project. All prior work is quite a mess, and massive. The project began with ~ 100 traps in a valley, each one given a numerical name. At random intervals, additional traps have been set up in this valley, also given...
  7. M

    VBA for GPS Coordinates

    Hello, I want to write a macro that gets the XY location from a GPS connected to my computer via a serial port. is this possible in excel, maybe i need to go to Access? Thanks Amanda
  8. B

    Text Manipulation Puzzle

    I am given a spreadsheet with 1 column. In this column, is a long string containing a variable list of gps coordinates. The syntax of the string is always the same, like this: LINESTRING(lat lon, lat lon, lat lon) My problem is that I need to switch each coordinate to be lon lat instead of...
  9. R

    VLOOKUP in 2 fields of numbers

    I have been looking through a lot of very similar threads on this particular subject but have thus far been unable to find a solution that works for me. I imagine that there is something on these forums that would work but I figured it couldn't really hurt to try posting my own thread. I have...
  10. S

    GPS conversions

    Help! Inexperienced with Excel. Need Excel 2007 formula(s) to convert longitude/latitude coordinates such as "N48-38-46.5" and "E088-19-14.4" into Degrees Minutes decimal format. All longitudes are N, and all latitudes E. Long/lat have separate columns. The N's and E's are followed by...
  11. T

    GPS Coordinates Format

    Hi everyone I'm trying to put together a sheet where a user can enter data into four cells (N,S,E,W via drop down list in the first box, degrees, minutes and seconds in the remaining three). Ie. S ## ## ##.## The formula =G4+(H4/60+I4/3600) then converts the data to a decimal value which...
  12. V

    GPS waypoint data to access form

    I would like to know if there is an easy way to capture coordinate data (lat, long, date/time stamp, etc) in an access form while using a tablet PC equipped with a usb GPS unit. I may need to collect up to 10 discrete location points per record. Any help with this would be appreciated. Thanks.

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back