=SEARCH("""",B2,1)

OR

=SEARCH(CHAR(34),B2)

If this post helps click Yes
---------------
Jacob Skaria


"Simon S" wrote:

Hi, I am trying to search for inverted commas in a text string using the
search formula, I tried to put the inverted comma within inverted commas but
that did not work i.e. =SEARCH(""",B2,1) ....thanks