# Remove always the same characteres from differents texts

#### andrefraga

##### New Member
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.

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### mumps

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

#### Yongle

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

#### andrefraga

##### New Member
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

##### Well-known Member
You are very welcome.

Replies
0
Views
273
Replies
14
Views
5K
Replies
0
Views
682