Trim after characters

[Kesser]

Hi

I have the below data where I want to trim the last "-2), if it appears.

6-2891

5-4795

4-5523-2

7-5533

Ordinarily I have used the below but only works if the rule is the same
=LEFT(C9,LEN(C9)-SEARCH("-",C9))

What can I use if it is in only selected cells in which I want to trim the string, so the non "-2" do not get trimed also

Thanks

 

[JimM]

How about

=IF(RIGHT(C9,2)="-2",LEFT(C9,LEN(C9)-2),C9)

edited to replace A1 with C9

 

[JimM]

Alternatively if the format of the data is always x-xxxx then simply

=LEFT(C9,6)

 

[pgc01]

Hi

Do you really mean "-2" or do you mean anything after a second "-" like

4-5523-2 -> 4-5523
4-123-5 -> 4-123
4-54-ABC -> 4-54

Also look at Jim's second post if the first 2 groups of digits are fixed length.

 

[Kesser]

Thanks both, used first example and worked perfectly
.