Remove all text after the second dash including the dash

[Sean15]

I have strings that contain text and two dashes. Is there a formula that will remove all text after the second dash including the dash?

Existing data

Tom Jones – check – 10/15/21

Tom Jones – cash – 10/20/21

Gilbert Transporting – credit card – 10/9/21



Required data.

Tom Jones – check

Tom Jones – cash

Gilbert Transporting – credit card



Required data will hopefully allow me to pivot several hundred rows of data. Could you help?



Regards,

 

[JGordon11]

Book2
	A	B
1	Tom Jones – check – 10/15/21	Tom Jones – check
2	Tom Jones – cash – 10/20/21	Tom Jones – cash
3	Gilbert Transporting – credit card – 10/9/21	Gilbert Transporting – credit card
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=LEFT(A1,FIND("–",A1,FIND("–",A1)+1)-1)