No just searhing for one lot, Jacobs answer worked, thanks anyway

"T. Valko" wrote:

Do you mean you're looking for double quotes " ?

A1 = look "for" this

=FIND("""",A2)

That's 4 double quotes " " " "

--
Biff
Microsoft Excel MVP


"Simon S" wrote in message
...
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