Ask Your Question
0

Regular expression search returns #VALUE! [closed]

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

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
0

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

dengar81 gravatar image

Alright, I was not enabling regex!

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 37 times

Last updated: Nov 21 '17