Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function | Excel Worksheet Functions | |||
Find Function | Excel Worksheet Functions | |||
.find =< function | Excel Programming | |||
Find Function | Excel Worksheet Functions | |||
backwards find function to find character in a string of text | Excel Programming |