I just don’t get it /:
I’m trying a very very simple SEARCH (formula) for numbers:
=SEARCH(A1;"[0-9]")
and it fails, no matter if the A1 is empty, contains text, or numbers.
It gives me #VALUE!
as an error.
Why is that?
I just don’t get it /:
I’m trying a very very simple SEARCH (formula) for numbers:
=SEARCH(A1;"[0-9]")
and it fails, no matter if the A1 is empty, contains text, or numbers.
It gives me #VALUE!
as an error.
Why is that?
Enable regular expressions option is activated.
Because
=SEARCH("[0-9]";A1)
i.e. the arguments swappedIf you would read the HELP for SEARCH, you maybe would realize that’s the search-expression should be the first
argument…not the second
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.
Wrong order.