Using find function to find a single inverted comma in a cell
Using find function to find a single inverted comma in a cell
(OP)
How do I do this?
I want something like =FIND(""",A2,3) which of course does not work ... any ideas?
I want something like =FIND(""",A2,3) which of course does not work ... any ideas?
Read the Eng-Tips Site Policies at FAQ731-376: Eng-Tips.com Forum Policies





RE: Using find function to find a single inverted comma in a cell
=SEARCH("""",A2) will find the first " character
RE: Using find function to find a single inverted comma in a cell
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: Eng-Tips.com Forum Policies
RE: Using find function to find a single inverted comma in a cell
"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."
RE: Using find function to find a single inverted comma in a cell
Read the Eng-Tips Site Policies at FAQ731-376: Eng-Tips.com Forum Policies
RE: Using find function to find a single inverted comma in a cell
As FrancisL has stated ...
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
RE: Using find function to find a single inverted comma in a cell
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: Eng-Tips.com Forum Policies