Hi
I have the below data where I want to trim the last "-2), if it appears.
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
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