Results 1 to 8 of 8

Text to columns, pick text from a string in cell

Threaded View

soli004 Text to columns, pick text... 12-30-2016, 10:09 AM
AliGW Re: Text to columns, pick... 12-30-2016, 10:20 AM
soli004 Re: Text to columns, pick... 12-30-2016, 11:23 AM
AliGW Re: Text to columns, pick... 12-30-2016, 11:37 AM
Glenn Kennedy Re: Text to columns, pick... 12-30-2016, 12:21 PM
soli004 Re: Text to columns, pick... 12-30-2016, 03:45 PM
Glenn Kennedy Re: Text to columns, pick... 12-30-2016, 04:35 PM
mike7952 Re: Text to columns, pick... 12-30-2016, 07:55 PM
  1. #1
    Registered User
    Join Date
    08-11-2010
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    93

    Text to columns, pick text from a string in cell

    Hello forum,
    Text to Columns does not work for this text string, it is picked up from GPS data and the text strings differ.
    Is there a way to use find text in string and pick out the correct data and ignore the rest!?

    I attached an sample file how it looks like and the wanted result

    I hope you experts here have an solution to this problem.

    Happy New Year

    Regards
    Attached Files Attached Files
    Last edited by soli004; 12-30-2016 at 03:48 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pick out text from middle of a string
    By aaron.phelan12345 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-06-2015, 01:00 PM
  2. [SOLVED] Search for a text string and return given text string to adjacent cell
    By hecgroups in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2015, 04:50 AM
  3. Replies: 2
    Last Post: 04-09-2014, 11:48 AM
  4. [SOLVED] formula to pick out text in middle of string and return
    By Burt_100 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-24-2014, 05:32 PM
  5. [SOLVED] Function to pick out % from text string
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-05-2013, 06:36 AM
  6. [SOLVED] Find partial text string within another text string return original text into cell.
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-17-2013, 02:58 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1