Search text for quote marks

  • Thread starter Thread starter Neil T
  • Start date Start date
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)
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for function/argument "exclude". 0
Match similar names 3
Can I use "*xyz" in a formula 2
Searching for text within formula 21
char(10) and double quotes 2
Finding dates without attention to data formats 1
Mark Zuckerberg / European Parliament 6
Error: Compile Error,ByRef argument type mismatch 0

Back
Top