+ Reply to Thread
Results 1 to 2 of 2

Extract Text after hypen or dash

  1. #1
    Registered User
    Join Date
    09-05-2017
    Location
    Chicago, Illinois, USA
    MS-Off Ver
    2010
    Posts
    5

    Extract Text after hypen or dash

    In one cell, people have put both their name and location. I want to grab the location and move it to its own cell. I am trying to grab all the text in a cell after a hyphen (-). However, some of the cells use an em dash instead (—)

    Mark - St. Louis
    Matt — Chicago

    I am using the formula =TRIM(REPLACE(A2,1,FIND("-",A2),"")). Is there a way I could amend the formula to look for the hyphen or the em dash?


    Thanks,

    Mark
    Last edited by MarkO'Donnell; 11-06-2017 at 08:49 PM. Reason: did not call in em dash

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2310 Win 11 Home 64 Bit
    Posts
    23,139

    Re: Extract Text after hypen or dash

    The "dash" is actually an em dash and needs to identified as shown in this article.

    https://excel.tips.net/T002118_Inser...nt_Dashes.html
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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] 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
  2. how to add hypen between 2 numbers in cell
    By JKONT in forum Excel General
    Replies: 2
    Last Post: 12-23-2012, 10:57 AM
  3. Replies: 11
    Last Post: 12-17-2012, 12:02 PM
  4. Stopping Excel from interpreting hypen
    By Bob Summers in forum Excel General
    Replies: 2
    Last Post: 12-26-2009, 07:43 AM
  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. [SOLVED] 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
  8. Ignoring everthing after a hypen
    By Steve in forum Excel General
    Replies: 5
    Last Post: 09-09-2005, 04:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1