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 need is
=SEARCH("[a-c]";"abc123")
=SEARCH("[^a-c]";"abc123")
These work as you described.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
