View Single Post
  #1   Report Post  
Caveman1957 Caveman1957 is offline
Junior Member
 
Posts: 18
Default 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?