Closed Thread
Results 1 to 4 of 4

Google Location History

  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    Munford, TN
    MS-Off Ver
    2010
    Posts
    4

    Google Location History

    I'm am trying to extract latitude from a cell that has the longitude and latitude separated by a space followed by a space and addition numbers. Here are three examples:

    -89.8498682 35.467965 0
    -89.849981 35.468031 82
    -89.8500404 35.4681497 107

    I tried: =MID(B262,LEN(B262)-LEN(C262),FIND(" ",RIGHT(B262,LEN(B262)-LEN(C262)))) where B2 is the source and C2 is the extracted longitude and it seems to work some of the time, but here is an example of when it doesn't:

    -89.8499246 35.468019 0 -89.8499246 6 35.46801

    I thank you in advance for any help you can provide.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,400

    Re: Google Location History

    I was with you with the first three examples and then you threw in the much longer string with seemingly two pairs of Lat/Long co-ordinates.

    It's probably best if you upload an example workbook that contains all permutations and manually add the results you expect.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    07-09-2014
    Location
    Munford, TN
    MS-Off Ver
    2010
    Posts
    4

    Re: Google Location History

    I see now how that could be confusing, anyways, here is the workbook. Sheet 1 is the original KML file saved as a workbook. Formulas is where I'm trying to get the data to work with. You can see how the results in Column E do not work properly.
    Attached Files Attached Files

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,400

    Re: Google Location History

    Thread closed at request of OP.

    Being opened in CS forum.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Moving *.xlsx from current location including Sub Folders to another location
    By mvinay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2014, 03:55 AM
  2. Replies: 2
    Last Post: 08-01-2013, 12:14 PM
  3. [SOLVED] [Help]macro to open file browser, to select a location, and save the location to a cell
    By zhuleijia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2013, 09:56 AM
  4. Replies: 1
    Last Post: 10-31-2012, 11:19 AM
  5. Replies: 0
    Last Post: 11-05-2009, 04:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1