+ 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 VersionVersion 2411 Win 11
    Posts
    24,377

    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. 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