Isolating values left of two identical characters

[goosteroo]

Hi, I'm trying to work on a formula that isolates values between two identical characters.

On A1, there's PR1110-9_004-BloodGame-160x600.

I want the result to populate on B1 with PR1110-9_004.

So, the formula should isolate the value left of the second "-"

Thanks.

 

[c_m_s_jr]

=left(a15,find("-",a15,find("-",a15)+1)-1)

 

[goosteroo]

thank you!