URGENT!!! remove everything after a second dash in a string (and the second dash)

[Jeffrey Green]

I have this
[TABLE="width: 174"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1174958190-B33TB-DAA[/TD]
[/TR]
[TR]
[TD]1174988827-B33TB-RTR[/TD]
[/TR]
[TR]
[TD]1175002840-B33TB-[/TD]
[/TR]
[TR]
[TD]AC042130-AECNA-AP[/TD]
[/TR]
[TR]
[TD]1175054679-B33TB-

I only want the data BEFORE the second dash[TABLE="width: 174"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1174958190-B33TB[/TD]
[/TR]
[TR]
[TD]1174988827-B33TB[/TD]
[/TR]
[TR]
[TD]1175002840-B33TB[/TD]
[/TR]
[TR]
[TD]AC042130-AECNA[/TD]
[/TR]
[TR]
[TD]1175054679-B33TB[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Try:

Excel Workbook
	A	B	C
1	1174958190-B33TB-DAA		1174958190-B33TB
2	1174988827-B33TB-RTR		1174988827-B33TB
3	1175002840-B33TB-		1175002840-B33TB
4	AC042130-AECNA-AP		AC042130-AECNA
5	1175054679-B33TB-		1175054679-B33TB
Sheet

 

[jtakw]

Hi,

Another way:

Book1
	A	B
1	1174958190-B33TB-DAA	1174958190-B33TB
2	1174988827-B33TB-RTR	1174988827-B33TB
3	1175002840-B33TB-	1175002840-B33TB
4	AC042130-AECNA-AP	AC042130-AECNA
5	1175054679-B33TB-	1175054679-B33TB
Sheet91

Cell Formulas
Range	Formula
B1	=REPLACE(A1,FIND("#",SUBSTITUTE(A1,"-","#",2)),255,"")

 

[Jeffrey Green]

You are a life saver!!!!!!!!!!!!!!!!!!!!!! THANKS SO MUCH, perfect. Not sure how it works, but good for now!

 

[hiker95]

Jeffrey Green,

If the following is in cell A1:
1174958190-B33TB-DAA

In cell B1 enter the following formula:
=LEFT(A1,FIND("@",SUBSTITUTE(A1,"-","@",(LEN(A1)-LEN(SUBSTITUTE(A1,"-","")))/LEN("-")))-1)

Cell B1 will display:
1174958190-B33TB

And, then copy cell B1 down to the last used row in column A

 

[jtakw]

You're welcome, glad to contribute.

AhoyNC's formula in Post #2 can also be shortened to this:

=LEFT(A1,FIND("#",SUBSTITUTE(A1,"-","#",2))-1)