How Do I Find Double Quote in Excel

[JeremyANG]

Can someone please let me know if there is any escape characters in Excel. I'm trying to do something like this:

=FIND(""",A1)


Thankyou.

 

[Aladin Akyurek]

Can someone please let me know if there is any escape characters in Excel. I'm trying to do something like this:

=FIND(""",A1)


Thankyou.

Something like:

=FIND(CHAR(34),A1)

 

[shg]

Or one more quote:

=FIND("""", A1)

 

[Rick Rothstein]

Or one more quote:

=FIND("""", A1)

Let me see if I can clarify why that is the case for the OP. All text constants in a formula are identified by enclosing them in quote marks. For example...

="This is a quote"

Now let's say you wanted an actual quote mark between the words "This" and "is". If you wrote this...

="This " is a quote"

Excel would not know you meant that second one as an actual quote mark character and not as a closing quote mark for a text constant. To help Excel figure things out, the rule is to double up an actual quote mark character contained in a quoted text constant. So the proper way to add the quote mark character to the text is this way...

="This "" is a quote"

Now, lets remove the first word and its trailing space...

=""" is a quote"

See what happens when the quote mark character is the first character of the text... you end up with three quote marks... the first one is the required one indicating a text constant and the next two are to tell Excel that the text has an actual quote mark character there. Okay, now let's remove the rest of the text...

=""""

What is now left is four quote marks... the two outer ones are the ones that tell Excel what is between them is a text constant and the remaining two quote marks are the ones that tell Excel there is an actual quote mark character at that location.

 

[JeremyANG]

Something like:

=FIND(CHAR(34),A1)

Works like MAGIC!!!
Thanks much

 

[Aladin Akyurek]

Works like MAGIC!!!
Thanks much

You are welcome.