Hi,

I am trying to come up with a formula that extracts text before the first instance of any one of three symbols: period, hyphen, and forward slash.
So far I have the below formula which can only handle looking for one of the three symbols at a time.

=IF(AND((A2="Germany"),IFERROR(FIND("-",B2)>0,FALSE)),LEFT(B2,MIN(FIND("-",B2))-1))

What I need is a formula that will give me the output in column C of the image below.
Any assistance would be great.

Data.png