Extract string from cell with different lenghts

Hi, everyone!

I am trying to automatically extract the name of clients from a string and am getting stuck in the logics... I have tried a different combination of LEFT, RIGHT, FIND and MID.

Here are two examples of cells:
Z-BR-Par Perfeito CPL RTT BR S5-
OMGS-Carefree Curitiba CPL BR RTT

The expected result of the first one is Z-BR and the second one is OMGS. So, as you can see, some names contain a dash, what prevents me from using is to extract the string.

I tried something like this but it did not keep the string as needed.
=LEFT(C1,(FIND(" ",C1)-((FIND(" ",C1)-(FIND("-",C1))+1))))

My idea was to count until the space (" ") and subtract the numbers of characters from that space to the first dash (-) to the left. I am failing to count this second step.

I might be overcomplicating, so any suggestion is greatly appreciated!

Try this ...

=LEFT(C1,FIND("|",SUBSTITUTE(C1,"-","|",LEN(LEFT(C1,FIND(" ",C1)))-LEN(SUBSTITUTE(LEFT(C1,FIND(" ",C1)),"-",""))))-1)

Hello Phuocam and CK76.

Thank you very much for the help. It worked perfectly. I really appreciate he detailed explanation! It will certainly help to build the logic in my head for next situations.

I had tried using SUBSTITUTE before but I was placing in the wrong place.

Thanks and cheers!