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
Bookmarks