Ask Your Question

Regular expression search returns #VALUE! [closed]

asked 2017-11-21 19:43:28 +0200

dengar81 gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by dengar81
close date 2017-11-21 19:53:04.946944

1 Answer

Sort by » oldest newest most voted

answered 2017-11-21 19:52:47 +0200

dengar81 gravatar image

Alright, I was not enabling regex!

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-11-21 19:43:28 +0200

Seen: 40 times

Last updated: Nov 21 '17