Using find function to find a single inverted comma in a cell 2

[ColourfulFigsnDiags]

How do I do this?

I want something like =FIND(""",A2,3) which of course does not work ... any ideas?

Read the Eng-Tips Site Policies at FAQ731-376

 

[FrancisL]

=FIND("'",A2,3) works for a single inverter comma
=SEARCH("""",A2) will find the first " character

 

[ColourfulFigsnDiags]

Thanks Francis, the search one worked perfectly

What is the key difference between find and search? It seems like search is just a simpler version of find (i.e. it finds just one character rather than a string)

Read the Eng-Tips Site Policies at FAQ731-376

 

[FrancisL]

From the Excel Help
"FIND finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text.
You can also use SEARCH to find one text string within another, but unlike SEARCH, FIND is case sensitive and doesn't allow wildcard characters."

 

[ColourfulFigsnDiags]

Ahhh cool, seems a bit weired having two things which do essentially the same thing but for a few options ... probably a historical thing.

Read the Eng-Tips Site Policies at FAQ731-376

 

[yogia]

Ahhh cool, seems a bit weired having two things which do essentially the same thing but for a few options ... probably a historical thing.

Hi ColurfulFigsnDiags:

As FrancisL has stated ...

You can also use SEARCH to find one text string within another, but unlike SEARCH, FIND is case sensitive and doesn't allow wildcard characters."

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC

http://www.energyefficientbuild.com

 

[ColourfulFigsnDiags]

Yogia, I understand that, but essentially they are the same function i.e. FIND is a subset of SEARCH ... the only difference between the two is a few options which could be included within the function itself.

Forinstance you could have =SEARCH([search text],[search cell],[case sensative(True/false)], [Allow Wildcards (True/false)]) and you would have exactly the same things as FIND. So therefore the only reason I can imagine having the two is to allow backward compatibility.

Read the Eng-Tips Site Policies at FAQ731-376