Search text for quote marks

N

Neil T

How can I write a formula to search a text cell for quote
marks (")? FIND and SEARCH don't accept " as an argument
(Excel 2002)
 
J

JE McGimpsey

As with any other string function in XL, you need to double the quote
marks when within quotes, e.g.:

=FIND("""",A1)

alternatively, you can use CHAR()

=FIND(CHAR(34),A1)
 
Top