+ Reply to Thread
Results 1 to 12 of 12

Extract text after specific words

  1. 08-30-2019, 07:17 AM #1
    rayted
    rayted is offline
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Extract text after specific words

    Hi guys

    In cell A1, I have 2 lines of data. However, it will always start with: Last Updated:

    Can someone advise on a formula, that basically instructs excel to return all the text AFTER 'Last updated:'?

    Thank you!
    Thanks,

    R.


    Reply With QuoteRegister To Reply
  2. 08-30-2019, 07:19 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Extract text after specific words

    Try the SUBSTITUTE function ( substitute your string with "")
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 08-30-2019, 07:21 AM #3
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,723

    Re: Extract text after specific words

    You could do this:

    =SUBSTITUTE(A1,"Last updated: ","")

    Change the A1 to the cell that contains the data. Note that I have included a space after Last updated:, as I would expect that you have one there.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  4. 08-30-2019, 07:23 AM #4
    rayted
    rayted is offline
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Extract text after specific words

    Hi Pete,

    This is returning the cell containing the data, not the data/text after 'Last updated:'?...

    thank you
    Reply With QuoteRegister To Reply
  5. 08-30-2019, 07:29 AM #5
    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,914

    Re: Extract text after specific words

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  6. 08-30-2019, 07:31 AM #6
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,723

    Re: Extract text after specific words

    Quote Originally Posted by rayted View Post
    Hi Pete,

    This is returning the cell containing the data, not the data/text after 'Last updated:'?...

    thank you
    Remove the space after Last updated: in my formula.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  7. 08-30-2019, 08:06 AM #7
    rayted
    rayted is offline
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Extract text after specific words

    still no luck Pete.

    See cell A43 on the first tab, sheetattached (downloaded to excel from google sheet, using an import range)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 08-30-2019, 08:13 AM #8
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,723

    Re: Extract text after specific words

    There is nothing that says "Last updated:" You have numbered updates like "1st update:", "2nd update:" and so on.

    Pete
    Reply With QuoteRegister To Reply
  9. 08-30-2019, 08:19 AM #9
    rayted
    rayted is offline
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Extract text after specific words

    sorry that tab is supposed to be hidden! try the 2nd tab (Admin snapshot) thank you! cell a43
    Reply With QuoteRegister To Reply
  10. 08-30-2019, 08:37 AM #10
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,723

    Re: Extract text after specific words

    Change the formula in A43/44 to this:

    =SUBSTITUTE(A54,"Last Updated: ","")

    Your formula was looking at cell A51.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  11. 08-30-2019, 09:27 AM #11
    rayted
    rayted is offline
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Extract text after specific words

    cheers pete!
    Reply With QuoteRegister To Reply
  12. 08-30-2019, 01:05 PM #12
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,410

    Re: Extract text after specific words

    Quote Originally Posted by Pete_UK View Post
    Change the formula in A43/44 to this:

    =SUBSTITUTE(A54,"Last Updated: ","")
    I am thinking that since the text always starts with "Last Updated: ", and since the desired text to retrieve appears to always be less than 100 characters long, that this formula would be "simpler"...

    =MID(A54,15,99)

    Of course, the 99 could be increased if the text could possibly be longer.
    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] Formula to extract the text before one of two specific words
    By The_Snook in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-02-2017, 07:21 AM
  2. [SOLVED] Extract specific words/strings from a cell
    By deerguy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-07-2017, 05:17 PM
  3. [SOLVED] Extract specific words from large text
    By jesse030 in forum Excel General
    Replies: 7
    Last Post: 04-15-2016, 07:27 AM
  4. 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
  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. How can i extract specific words from a cell?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 06-17-2013, 12:27 PM
  7. Extract specific words from cells
    By Santa-D in forum Excel General
    Replies: 6
    Last Post: 06-18-2006, 11:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1