Ask Your Question

Why does SEARCH with regular expression (regex) fail with #VALUE! [closed]

asked 2017-03-03 10:28:28 +0200

Andy gravatar image

I just don't get it /:

I'm trying a very very simple SEARCH (formula) for numbers:


and it fails, no matter if the A1 is empty, contains text, or numbers.

It gives me #VALUE! as an error.

Why is that?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-26 16:46:55.261399


Enable regular expressions option is activated.

Andy gravatar imageAndy ( 2017-03-03 10:30:53 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2017-03-03 10:41:45 +0200

erAck gravatar image


  1. it should be =SEARCH("[0-9]";A1) i.e. the arguments swapped
  2. Tools→Options→Calc → Enable regular expressions in formulas must be active
edit flag offensive delete link more

answered 2017-03-03 10:42:47 +0200

Wrong order.

edit flag offensive delete link more

answered 2017-03-03 10:40:47 +0200

karolus gravatar image

If you would read the HELP for SEARCH, you maybe would realize that's the search-expression should be the first argument…not the second

edit flag offensive delete link more


You don't need to be offensive, man – don't you think I googled and read several help pages? It's an easy to miss detail.

Andy gravatar imageAndy ( 2017-03-03 13:41:34 +0200 )edit

Question Tools

1 follower


Asked: 2017-03-03 10:28:28 +0200

Seen: 3,945 times

Last updated: Mar 03 '17