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 function)
and
therefore, cannot interpret the "[a-c]" as "a", "b", or "c".
I also tried out the SEARCH function, and it works the way Joe said it
worked.
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.
Doesn't the help for FIND say that it supports regular expressions? Or did I
confuse it with SEARCH somehow?
Here at work I don't have access to any Calc documentation, but maybe
there's some at OOO that I've missed.
The reason I'm using FIND is that it only searches within a specified cell.
I want to check the contents of the cell to see if certain characters are
present. Is there a better way to do this?
I really appreciate your comments and suggestion. :-)
