+ Reply to Thread
Results 1 to 4 of 4

Need Help to extract certain words from one cell

  1. #1
    Registered User
    Join Date
    06-16-2021
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    4

    Question Need Help to extract certain words from one cell

    Hello everyone,

    I hope someone could help me out with a query.

    One cell in excel has the following

    Date - 25/05/2021 - 13/05/2023
    1. Standard / Adult / 12-99 / USD 1244.00
    2. Standard / Child / 10-11 / USD 686.00

    I need only Adult / 12-99 and Child / 10-11 to be moved to another single cell.

    Can anyone help?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Need Help to extract certain words from one cell

    Maybe this???


    =TRIM(MID(SUBSTITUTE("/"&$A1,"/",REPT(" ",100)),600,200))&" "&TRIM(MID(SUBSTITUTE("/"&$A1,"/",REPT(" ",100)),900,200))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    06-16-2021
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    4

    Re: Need Help to extract certain words from one cell

    Thanks Glen, That worked

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Need Help to extract certain words from one cell

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract Words for a cell
    By namluke in forum Excel General
    Replies: 14
    Last Post: 01-07-2021, 01:23 PM
  2. [SOLVED] Extract one of five words from one cell into another
    By M12NIX in forum Excel General
    Replies: 6
    Last Post: 01-25-2017, 08:41 PM
  3. How to extract first 3 words from another cell
    By papusale in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-03-2015, 08:53 AM
  4. [SOLVED] extract last 2 words of cell
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-26-2014, 04:09 PM
  5. Replies: 7
    Last Post: 02-25-2014, 02:00 AM
  6. [SOLVED] Extract first two words of a cell
    By letangerang58 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2013, 01:12 PM
  7. Extract particular words from a cell
    By DeepakS in forum Excel General
    Replies: 2
    Last Post: 08-22-2011, 08:58 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