+ Reply to Thread
Results 1 to 4 of 4

Extract words till last, finding the 5th space from last

  1. 08-16-2015, 04:07 AM #1
    rajani.indegene
    rajani.indegene is offline
    Registered User
    Join Date
    04-19-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    12

    Extract words till last, finding the 5th space from last

    Hi All,

    I would like to extract words till last, finding the 5th space from last.

    Ex: "Value 10 9.0 72 80.0 23 18.0 66 70.0 43 50.0" in A1 cell

    I want "18.0 66 70.0 43 50.0" in B1 cell

    Preferably formula please...

    Many thanks for your help.

    Regards,
    Raj
    Reply With QuoteRegister To Reply
  2. 08-16-2015, 11:26 AM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Extract words till last, finding the 5th space from last

    Try this...

    =TRIM(LEFT(RIGHT(SUBSTITUTE(" "&A2," ",REPT(" ",100)),500),1000))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 08-17-2015, 05:19 AM #3
    rajani.indegene
    rajani.indegene is offline
    Registered User
    Join Date
    04-19-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Extract words till last, finding the 5th space from last

    Thank you very much for your help Tony...
    Reply With QuoteRegister To Reply
  4. 08-17-2015, 05:39 AM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Extract words till last, finding the 5th space from last

    You're welcome. Thanks for the feedback!
    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. How to find difference of two columns till blank space in column B
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2014, 04:11 PM
  2. [SOLVED] Seacrh till the last colum and select the words that are of same value in a column
    By pranayttt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-23-2013, 07:49 AM
  3. [SOLVED] looking formula for Extract Specific WORDs in existing LONG Words
    By santosh226001 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-07-2013, 08:21 AM
  4. [SOLVED] Macro to copy the data till end though there is space in between
    By suyogpatil in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-25-2013, 08:55 AM
  5. [SOLVED] How to copy all character till first space which begins with "RXO" data
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-06-2013, 07:35 AM
  6. Copying Values till the next blank space
    By Recycle_Bin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2009, 11:13 PM
  7. Finding last row till data is there and calculating
    By rajaid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2009, 12:03 PM

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