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)))
"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 "Dusty Teal 3-4 Sleeve Kimono with Lace Trim - M" returns "Dusty Teal 3"
I use to have success using =LEFT(Z1,(FIND(")",Z1))) as an alternative formula but it returns #value.
Anyone have another option I could try?
Thanks!
Example:
=TRIM(LEFT(Z1,(FIND("-",Z1,1)-1)))
"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 "Dusty Teal 3-4 Sleeve Kimono with Lace Trim - M" returns "Dusty Teal 3"
I use to have success using =LEFT(Z1,(FIND(")",Z1))) as an alternative formula but it returns #value.
Anyone have another option I could try?
Thanks!