Find Function looking for one Quotation mark

[MrLookout9]

Hello and thank you for your time,

I am trying to take a string of text and remove everything after the first quotation mark ("). For instance:

ab c "123" def becomes ab c

Here is my formula:

=left(a1,len(a1)-find(""",a1))

Excel does not like """

I have tried """" and '"'.


Quite the conundrum. Any thoughts?

 

[Asala42]

Try:

LEFTT(A1,FIND("""",A1)-1)