Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Regular expression search returns #VALUE!

Here is my problem:

Col A | Col B | Res

1 | =search("[:digit:]", A1) | #VALUE!

So even if I just do the most basic Regex, I get a #VALUE! error. Why would that be? I have enabled regular expressions and wildcards.