Thread: Check if there is a space in a string as test for IF
View Single Post
  #2   Report Post  
Caveman1957 Caveman1957 is offline
Junior Member
  
Posts: 18
Default
I have found an answer.

If I enclose the search in an ISERR() then it works.

ISERR(SEARCH(" ",G2)) result of this is either TRUE or FALSE.
Reply With QuoteReply With Quote