+ Reply to Thread
Results 1 to 11 of 11

Extracting particular data from a string of text in a cell...

  1. 08-04-2014, 10:35 PM #1
    Reggie A
    Reggie A is offline
    Registered User
    Join Date
    07-19-2013
    Location
    South Florida
    MS-Off Ver
    Excel 2003
    Posts
    5

    Extracting particular data from a string of text in a cell...

    Seeking some guidance...I've seen some similar examples but nothing quite fully there.

    I am seeking a way to extract (3) items [Date, Description & Amount] from a string of texts that are grouped together in one cell. As shown in the attachment the goal would be to have a formula to extract the Date, Description, & Amount from that same string of text in the one cell. Immediate response would be greatly appreciated...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-04-2014, 10:58 PM #2
    gak67
    gak67 is offline
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Extracting particular data from a string of text in a cell...

    In column H
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    In column I
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    In column J
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.
    Reply With QuoteRegister To Reply
  3. 08-04-2014, 10:58 PM #3
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Extracting particular data from a string of text in a cell...

    Perhaps something like this?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 08-04-2014, 11:04 PM #4
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Extracting particular data from a string of text in a cell...

    try
    =TRIM(MID(SUBSTITUTE($A$3," ",REPT(" ",99)),COLUMNS($B:B)*99-98,99))
    ☚ Click ★ just below left if it helps, Boo?ath?
    Reply With QuoteRegister To Reply
  5. 08-04-2014, 11:05 PM #5
    clabulis
    clabulis is offline
    Forum Contributor
    Join Date
    05-04-2014
    Location
    New Jersey, United States
    MS-Off Ver
    Excel 2010, 2013
    Posts
    120

    Re: Extracting particular data from a string of text in a cell...

    Try This:

    Example Test 08.04.14.xlsx
    Reply With QuoteRegister To Reply
  6. 08-04-2014, 11:34 PM #6
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Extracting particular data from a string of text in a cell...

    Also this......

    Dates:
    Please Login or Register  to view this content.
    Description:
    Please Login or Register  to view this content.
    Amount:
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  7. 08-05-2014, 08:01 PM #7
    Reggie A
    Reggie A is offline
    Registered User
    Join Date
    07-19-2013
    Location
    South Florida
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Extracting particular data from a string of text in a cell...

    Thank you for this response…very helpful! Would it be possible to have you explain what each part is doing? I am trying to comprehend for future reference.
    Reply With QuoteRegister To Reply
  8. 08-05-2014, 08:02 PM #8
    Reggie A
    Reggie A is offline
    Registered User
    Join Date
    07-19-2013
    Location
    South Florida
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Extracting particular data from a string of text in a cell...

    Sorry previous reply is for AZUMI...
    Reply With QuoteRegister To Reply
  9. 08-05-2014, 08:03 PM #9
    Reggie A
    Reggie A is offline
    Registered User
    Join Date
    07-19-2013
    Location
    South Florida
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Extracting particular data from a string of text in a cell...

    Quote Originally Posted by azumi View Post
    Perhaps something like this?
    Thank you for this response…very helpful! Would it be possible to have you explain what each part is doing? I am trying to comprehend for future reference.
    Reply With QuoteRegister To Reply
  10. 08-05-2014, 08:04 PM #10
    Reggie A
    Reggie A is offline
    Registered User
    Join Date
    07-19-2013
    Location
    South Florida
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Extracting particular data from a string of text in a cell...

    Quote Originally Posted by Reggie A View Post
    Thank you for this response…very helpful! Would it be possible to have you explain what each part is doing? I am trying to comprehend for future reference.
    Thank you! Would you be able to explain what each formula is doing so that I can follow better for future use...
    Reply With QuoteRegister To Reply
  11. 08-06-2014, 01:04 AM #11
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,941

    Re: Extracting particular data from a string of text in a cell...

    =TRIM(MID(SUBSTITUTE(TRIM(SUBSTITUTE($A3,"Extracting:",""))," ",REPT(" ",LEN($A3))),(COLUMNS($H$3:H$3)-1)*LEN($A3)+1,LEN($A3)))
    Try this formula in "B3" and copy across
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    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. Extracting particular data from a string of text in a cell...
    By Reggie A in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 08-04-2014, 10:32 PM
  2. [SOLVED] Extracting data between 2 characters in a text string
    By Donga00 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-14-2013, 10:35 AM
  3. Extracting Text from a string in a Cell (Excel VBA)
    By jimmy_nora in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-22-2010, 05:30 AM
  4. Help extracting a particular string of text from a cell.
    By dcgrove in forum Excel General
    Replies: 2
    Last Post: 09-07-2010, 04:14 PM
  5. Extracting data from a text string
    By andrewc in forum Excel General
    Replies: 2
    Last Post: 09-08-2009, 08:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1