Help with Find function
 

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

Help with Find function
 

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)


On 30 May, 15:22, Extropian
wrote:
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

Help with Find function
 

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

"WhytheQ" wrote:

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)


On 30 May, 15:22, Extropian
wrote:
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

Help with Find function
 

Your formula is looking in A2. Make sure A2 is the cell that contains an
open parenthesis "(".

"Extropian" wrote in message
...
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