+ Reply to Thread
Results 1 to 4 of 4

Extract coordinates from a string of data

  1. 02-22-2024, 10:56 PM #1
    tbomdiggity
    tbomdiggity is offline
    Registered User
    Join Date
    05-17-2018
    Location
    Melbourne, australia
    MS-Off Ver
    Excel 2016
    Posts
    10

    Extract coordinates from a string of data

    Hi Guru's

    This one has me stumped. I have an abstract of some GPS co-ordinates that are in the wrong order, and need to be into their own columns.

    Can anyone help?
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by tbomdiggity; 02-22-2024 at 11:50 PM.
    Reply With QuoteRegister To Reply
  2. 02-22-2024, 11:31 PM #2
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,005

    Re: Extract coordinates from a string of data

    Try this in B2 and copy down.
    Please Login or Register  to view this content.
    Try this in C2 and copy down.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 02-22-2024, 11:50 PM #3
    tbomdiggity
    tbomdiggity is offline
    Registered User
    Join Date
    05-17-2018
    Location
    Melbourne, australia
    MS-Off Ver
    Excel 2016
    Posts
    10

    Re: Extract coordinates from a string of data

    Superstar - thank you windknife!
    Reply With QuoteRegister To Reply
  4. 02-22-2024, 11:53 PM #4
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,005

    Re: Extract coordinates from a string of data

    You are welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Relative screen coordinates. How to extract them from an Excel workbook?
    By NackJich in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-29-2018, 10:22 AM
  2. Relative screen coordinates. How to extract them from an Excel workbook?
    By NackJich in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-29-2018, 04:20 AM
  3. [SOLVED] Extract Coordinates from a picture in userform
    By alexgoaga in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-03-2018, 07:14 PM
  4. [SOLVED] Extract some data from a string
    By Str1der in forum Excel General
    Replies: 13
    Last Post: 05-24-2016, 09:13 AM
  5. Need to extract specific XYZ coordinates from a dataset
    By pdog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-02-2012, 02:52 PM
  6. Extract AutoCAD XYZ coordinates
    By rkoog in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2009, 08:35 AM
  7. [SOLVED] Extract data from String
    By SL in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-10-2006, 08:40 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1