I have a product name that contains the name and the size. I only want the product name and used the following to extract the text I want out.
Example:
=TRIM(LEFT(Z1,(FIND("-",Z1,1)-1))) where cell Z contains "Leopard Print Jumpsuit (Heather Grey) - Large" and it correctly comes out as "Leopard Print Jumpsuit (Heather Grey)"
However, the issue I am coming across is that some products have another "-" in the description such as "From Time to Time V-Neck Popcorn Sweater (Light Grey) - Small" and thus it returns "From Time To Time V".
How can I change the formula so that it will work across both description types?
Thanks.
Example:
=TRIM(LEFT(Z1,(FIND("-",Z1,1)-1))) where cell Z contains "Leopard Print Jumpsuit (Heather Grey) - Large" and it correctly comes out as "Leopard Print Jumpsuit (Heather Grey)"
However, the issue I am coming across is that some products have another "-" in the description such as "From Time to Time V-Neck Popcorn Sweater (Light Grey) - Small" and thus it returns "From Time To Time V".
How can I change the formula so that it will work across both description types?
Thanks.