+ Reply to Thread
Results 1 to 6 of 6

Capture the 2nd, 3rd words and so on..

Hybrid View

  1. 11-28-2017, 10:48 PM #1
    ALLANT
    ALLANT is offline
    Registered User
    Join Date
    04-13-2016
    Location
    Laguna Philippines
    MS-Off Ver
    O365 PRO PLUS
    Posts
    68

    Capture the 2nd, 3rd words and so on..

    Please help me out to provide the correct formula on how to get the desired data or words that i need. Attached is the sample sheet.
    Reply With QuoteRegister To Reply
  2. 11-28-2017, 11:44 PM #2
    FoxSeaLady
    FoxSeaLady is offline
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Capture the 2nd, 3rd words and so on..

    Hi

    The sample sheet did not attach.
    To attach the sample GoAdvanced then Manage Attachments select file and submit.

    Cheers
    Reply With QuoteRegister To Reply
  3. 11-28-2017, 11:53 PM #3
    ALLANT
    ALLANT is offline
    Registered User
    Join Date
    04-13-2016
    Location
    Laguna Philippines
    MS-Off Ver
    O365 PRO PLUS
    Posts
    68

    Re: Capture the 2nd, 3rd words and so on..

    Dear see attached..
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-28-2017, 11:56 PM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2404
    Posts
    13,410

    Re: Capture the 2nd, 3rd words and so on..

    Try this formula in B3 and fill down.
    Formula: copy to clipboard 
    =TRIM(RIGHT(SUBSTITUTE(A3," ",REPT(" ",99),1),99))
    Dave
    Reply With QuoteRegister To Reply
  5. 11-28-2017, 11:58 PM #5
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Capture the 2nd, 3rd words and so on..

    something like this?
    =TRIM(MID(A3,SEARCH(" ",A3)+1,LEN(A3)))
    Reply With QuoteRegister To Reply
  6. 11-29-2017, 01:00 AM #6
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2404
    Posts
    13,410

    Re: Capture the 2nd, 3rd words and so on..

    And another way.

    Formula: copy to clipboard 
    =TRIM(REPLACE(A3,1,FIND(" ",A3),""))
    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] Capture real time data/DDE capture
    By rajre in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-07-2022, 05:14 AM
  2. Identify the words or words in a cell that match a list on another sheet
    By DeanR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2016, 06:21 PM
  3. How to search for specific words in text string and assign category based on these words
    By apple_tree in forum Excel General
    Replies: 15
    Last Post: 10-12-2014, 08:53 AM
  4. Makro/Formula to count number of consecutive particular words in a list of random words
    By topkiwi1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-02-2014, 03:49 PM
  5. [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
  6. Find & delete duplicate words in a cell from a separat list of words that can be added to
    By peter hent in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2012, 04:00 AM
  7. excel search text, find non-match words from list, display nonmatch words
    By lgoans in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2012, 07:15 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