Extract text from a cell with multiple "-"

[gromden]

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.

 

[Phuoc]

Like this:

=LEFT(Z1,(FIND(")",Z1)))

 

[gromden]

Oh nice, it worked! Thanks!

 

[gromden]

A modification to the issue above. I tried using the above formula =LEFT(Z1,(FIND(")",Z1))) to this "Lilac Floral Smocked 3-4 Ruffle Sleeve Dress - S" but it returns #VALUE!

When I use LEFT($S433,(FIND("-",$S433,1)-1))) it returns Lilac Floral Smocked 3.

Any help is greatly appreciated to correct. Thanks!

 

[jtakw]

Wrong post.

 

[Peter_SSs]

Post #4 appears to be a duplicate to: Extract text from a cell with multiple "-"

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.