Formula to show excel cell value before the second hyphen

[tkeiffer]

Hello,
I have data that contains at least one hyphen or dash. I'd like to pull only the first 2 text areas before the second hyphen, and the entire cell if there is only one hyphen. In the example data below

AC-CO-AT

AC-COB

AC-COB-2CL

AC-INT-ECS-2CL

I'd like the formula to show:

AC-CO
AC-COB
AC-COB
AC-INT

Is this possible?
Thank you!!!!
T

 

[SanjayGMusafir]

Update your current version of excel and platform to help you better. You can use the link below for quick navigation

 

[tkeiffer]

Update your current version of excel and platform to help you better. You can use the link below for quick navigation

I updated my excel and platform

 

[Cubist]

Try this and drag it down.

=TEXTBEFORE(A1,"-",2,,,A1)

If you want a spilled formula then grab entire range.

=TEXTBEFORE(A1:A5,"-",2,,,A1:A5)

 

[tkeiffer]

That worked perfectly thank you!

 

[Cubist]

You're welcome. Cheers.