Help with formula returning #VALUE

[Sean15]

Hi:

I have a concatenate value in D16.

In K11 formula

=LEFT(D16,FIND("–",D16,FIND("–",D16)+1)-1)

intended to remove all text after the second dash from concatenate value in D16 is returning #VALUE.

Can you help please?

 

[Uhrlaff]

Can you upload your spreadsheet showing the data?

 

[RoryA]

I'd guess your FIND is failing. Are you sure the cells contain that kind of dash?

 

[Sean15]

@RoryA

Your suspicion is correct. Formula in K11 had the wrong kind of dash.
Thank you so much.