On Friday 05 January 2007 18:25, Galen wrote (regarding [users] Re: Problem
with regular expression in FIND() worksheet function):
<>
> The comma between the arguments to FIND was a typo in my posting. My actual
> worksheet has a semicolon there, as Joe indicated it should.
>
>
I agree with Joe (Joe Smith <[EMAIL PROTECTED]>) when he says that the FIND
function returns #VALUE on entering the parameters you have used. It
looks
like the FIND function can not understand regular expressions in the "find
text" portion of the function (i.e., the first argument to the functio
Galen wrote:
Suppose I enter the following expression into a cell on a Calc worksheet,
say, cell A1 for convenience:
=FIND("[a-c]","abc123")
...
I'm not sure how this gives you "1"; it gives me "#VALUE!" even after I
changed the "," to ";" (I do it all the time as well ;-))
I think what you