How to extract substring from a cell between certain characters in smartsheet

Options

Here I have multiple hyphens(-) but i want to only extract the text between the left most hyphen and right most hyphen

For eg: Email-Apple-banana-mango-No Response is the string and I want to extract Apple-banana-mango

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!