So what I'm trying to do is have a formula that can extract text that's separated by a "-" symbol. For example, I will receive an email with the subject line "Project - Location - Description" the problem is that the project/location is not always the same length of text so I cant use a middle, left, or right formula. What I need is a formula that starts and stops with the use of a "-" sign. I've attached an example below of what I would like it to do.
Input Subject Output (What I want) ProjectA - New York City, NY - Expiration Date New York City, NY Project123 - Orlando, FL - Closing Date Orlando, FL
How can I do this? Bonus points if you can apply it to the beginning project or end description as well. Any help would be appreciated!
Bookmarks