Excel Formula - Delete after last occurrence of delimiter 1

[Moebius01]

Hoping this is the right forum for this question.

I'm trying to come up with a formula to delete all characters after the last occurrence of a delimiter, but I keep getting stuck. I have something to work with text after a delimiter, but ran into a problem when the string contained in more than once.

If cell A1 contains "Corp-Acct-NYC" I need to return "Corp-Acct".

 

[bluedragon2]

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

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...