Help with Find function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I really need some help here. I am trying to find a "(" within a text string
in a column, but I get a #VALUE! error when I use it.

=FIND("(",A2,1)

How can I find the ( if it thinks it's part of the formula boundries? Please
tell me there's a way around this.

Thanks in advance!
Heather
 
in cell A1 I have the following string "john(quirk)"
in cell A2 I have the following formula =FIND("(",A1,1)
the formula is returning 5 which is what I'd expect !

J


(this question would be better aimed at the worksheetfunctions group)
 
I figured out what I did. Not ALL of the records had the "(" in it so I was
mistaking it as a formula error. Duhhh.

Thanks :)

Heather
 
Your formula is looking in A2. Make sure A2 is the cell that contains an
open parenthesis "(".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS word Find and Replace using Regex - Help required 0
lastrow function help 6
formulas for conditional formatting 5
find function not working with merged cells 2
value time formula help please 4
find and scroll to cell string value in Excel 2
Excel automation: how to employ Find function? 9
A generic "find" function 3

Back
Top