How to remove everything after 2nd "-" ?

[joshman108]

Cell value which I want altered is:

abc-abc-abc

with formula

LEFT(A2,(FIND("-",A2,(FIND("-",A2)+1)+1)))

which cuts down to abc-abc-

But how do I remove the dash at the end to leave:

abc-abc?

Thanks!

 

[Gerald Higgins]

Try

LEFT(A2,(FIND("-",A2,(FIND("-",A2)+1)+1))-1)

Or if the 2nd "-" is ALWAYS character 8. . .
=left(a2,7)

 

[joshman108]

Thanks!

 

[Trustee]

Hi there,


Hope this formula will help you:

=LEFT(A1, LEN(A1)-4)