Check if there is a space in a string as test for IF
I need to check if there is a space in a string(Cell) and use the result as a test in an if statement.
I tried using search() but if there is no space there is no result so I get #VALUE in my formula cell.
=IF(SEARCH(" ",G2),{split string at space},"FALSE")
Is there anything I can use that will get me a Boolean true false result that can be used?
|