Remove always the same characteres from differents texts

[andrefraga]

Hello,

I Have the below kind ot text that repeats over 100-200 lines:

8-LL-001D-RJS / MSIAG-01 - (GI) 1 tramo - ESPECIAL
8-LL-014D-RJS / MSIAG-02 -(GI) 1 tramo - FL
3-RJS-739 (PO) - 7 tramos
and many other "X-XX-XXX - X tramos"

I need a new text which is always the words left to the left of "X tramos.."
Example:
8-LL-001D-RJS / MSIAG-01 - (GI) 1 tramo - ESPECIAL -> 8-LL-001D-RJS / MSIAG-01 - (GI)
8-LL-014D-RJS / MSIAG-02 -(GI) 1 tramo - FL -> 8-LL-014D-RJS / MSIAG-02 -(GI)
3-RJS-739 (PO) - 7 tramos -> 3-RJS-739 (PO)

Atention that sometimes we have singular and sometimes plural (1 tramos, 2 tramos). Actually don't know if this matters.

Could anyone help me, please?
Thanks in advance!

 

[mumps]

If there will always be ")" character to the left of "1 tramos", this formula should work: =LEFT(A1,FIND(")",A1,1))

 

[Yongle]

This may not apply to the rest of your data but it works with the sample data
=LEFT(A1,SEARCH(")",A1))

 

[andrefraga]

If there will always be ")" character to the left of "1 tramos", this formula should work: =LEFT(A1,FIND(")",A1,1))

Worked pretty well!
Thanks!

 

[mumps]

You are very welcome.