I have a string of text that I would like to keep everything to the left of the furthest right "-". See the example below. I have tried many variations of formulas including LEFT, RIGHT, LEN, SEARCH, FIND, but have been unable to find the right formula. The example below is what I am looking to apply a formula to.
Men's Long Sleeve Oxford-WHT-3XL
Men's Blue Manager Polo-BLU-3XL
ACME Polo Shirt-WHT-SM
ACME Long Sleeve Polo Shirt-WHT-SM
The result I need to be able to get:
Men's Long Sleeve Oxford-WHT
Men's Blue Manager Polo-BLU
ACME Polo Shirt-WHT
ACME Long Sleeve Polo Shirt-WHT
Bookmarks