×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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?

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

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

RE: Using find function to find a single inverted comma in a cell

(OP)
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: Eng-Tips.com Forum Policies  

RE: Using find function to find a single inverted comma in a cell

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."

RE: Using find function to find a single inverted comma in a cell

(OP)
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: Eng-Tips.com Forum Policies  

RE: Using find function to find a single inverted comma in a cell

Quote:


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 ...

Quote:


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

RE: Using find function to find a single inverted comma in a cell

(OP)
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: Eng-Tips.com Forum Policies  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources