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

[Jeffrey Green]

I have this

1174958190-B33TB-DAA

1174988827-B33TB-RTR

1175002840-B33TB-

AC042130-AECNA-AP

1175054679-B33TB- I only want the data BEFORE the second dash 1174958190-B33TB 1174988827-B33TB 1175002840-B33TB AC042130-AECNA 1175054679-B33TB <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

 

[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)