+ Reply to Thread
Results 1 to 4 of 4

extract text after second dash

  1. 06-03-2018, 12:47 AM #1
    L.LEE is offline
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    238

    extract text after second dash

    Hi

    Could someone help me with the formula to extract the text after the second dash?
    i.e. extract "32" from "Yearly {Total 2-Month Average Trade Volume} (2018) - 32"

    thanks
    Reply With QuoteRegister To Reply
  2. 06-03-2018, 01:03 AM #2
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,936

    Re: extract text after second dash

    One way...
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    BSB
    Reply With QuoteRegister To Reply
  3. 06-03-2018, 01:03 AM #3
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,658

    Re: extract text after second dash

    This will work on the one example provided:

    =TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",99)),98))
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 06-03-2018, 03:25 AM #4
    jtakw is offline
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: extract text after second dash

    Hi,

    In case you need the result as a Real Number for further math, just add +0 or *1 at the end of either formulas in Post #2 and #3.
    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. Extract Text after hypen or dash
    By MarkO'Donnell in forum Excel General
    Replies: 1
    Last Post: 11-06-2017, 08:35 PM
  2. Space between text and dash
    By tantcu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-04-2013, 01:36 PM
  3. [SOLVED] How to get a Dash"-" in string , when extract using GetMatch Function?
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-24-2013, 01:29 AM
  4. Various length alphanumeric field with and without a dash - need to extract numbers
    By Rysky75L9 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-17-2012, 12:02 PM
  5. [SOLVED] Nw how do i extract text from a text seperated by a dash.
    By all4excel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-26-2007, 05:30 AM
  6. Text after a dash
    By Steve in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-25-2006, 11:10 PM
  7. understanding dash dash in a excel formula
    By ldebner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2005, 10:05 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