In Calc if we have 2 cells setup like this:
A1: "A"
B1: =FIND(" ",A1)
B1 then shows: #VALUE!
I think I’m getting this error because a space is not found in the value in cell A1.
But how do I test for this error and/or bypass it? I want to do something if I find the space, and do something else if I don’t.
Here what I’ve already looked at/tried:
-
help says nothing about what to expect if the search string is not found.
-
tried checking it for -1
-
tried to use IFERROR and ISERROR functions on it. Perhaps I’m using them wrong??
-
B1: =SEARCH(" ",A1)
-
B1: =SEARCH("[:blank:]",A1)
-
B1: =FIND(" ",A1)
-
B1: =FIND("[:blank:]",A1)