Hi, I am new to this forum and I am hoping that I have some excel experts here that can help with a formula issue I am having. What I want to do is remove everything to the right of a hyphen from a field, but the issue is that some fields have multiple hyphens.
How would I go about doing this?
Here is a sample of what I am looking to do.
Web Work - 1
Web-Work - 1
Lots-Of-Web-Work - 7
I would like to make
Web Work
Web-Work
Lots-Of-Web-Work
Basically, I want to remove everything to the right of the last hyphen in the string, including the hypen itself. All the searches I have found online remove everything after the first hyphen or a specific numbered hyphen in the string. My issue is that different rows have different number of hypens. Formulas such as =LEFT(A2,FIND("-",A2)-2) just aren't cutting it. I would love to have a formula where I can just click and drag down in a separate column to create this new string, as I have some 4000 lines that I need to remove the back hyphen for, and everything after it.
Thanks in advance for any help you can provide!
Bookmarks