Check if there is a space in a string as test for IF

[Caveman1957]

I need to check if there is a space in a string(Cell) and use the resul
as a test in an if statement.

I tried using search() but if there is no space there is no result so
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 resul
that can be used

 

[Claus Busch]

Hi,

Am Fri, 8 Mar 2013 14:41:53 +0000 schrieb Caveman1957:

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?

you can use TextToColumns with space as deliniter. If there is a space
the string will be split.
Or use formula:
=IF(ISNUMBER(FIND(" ",G2)),{split string at space},"False")


Regards
Claus Busch