Excel formula help

[Simon S]

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

 

[T. Valko]

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

A1 = look "for" this

=FIND("""",A2)

That's 4 double quotes " " " "

 

[Jacob Skaria]

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

OR

=SEARCH(CHAR(34),B2)

If this post helps click Yes

 

[Simon S]

it worked thanks =SEARCH(CHAR(34),B2)

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

OR

=SEARCH(CHAR(34),B2)

If this post helps click Yes

 

[Simon S]

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

 

[Simon S]

No just one lot, Jacobs CHAR34 worked, thanks anyway

 

[T. Valko]

Ooops!

A1 = look "for" this
=FIND("""",A2)

Should be:

=FIND("""",A1)

I've had a lot of ooopses the last couple of days!

 

[Simon S]

No just one lot, Jacobs CHAR34 worked, thanks anyway

 

[Shane Devenshire]

I'm not saying that Jacob's solution doesn't work, but so does Valko's

=FIND("""",A1)
or
=FIND(CHAR(34),A1)

both work and are shorter then SEARCH.

As was stated this is four double-quotes in a row!

 

[T. Valko]

I'll have to remember CHAR(34). That seems less cryptic.

 

[T. Valko]

I'm pretty sure my suggestion works. If it didn't work for you you'd have
give me more detail as to what *exactly* you're trying to do.