Thread: Test to see if cell contains a space?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
  
Posts: 1,071
Default Test to see if cell contains a space?
If(A1=" ","Yes","No")

"Rick" wrote in message
...
It'll return a yes, if the cell contains a space.

Ideas?

Thank you.
Rick

Reply With QuoteReply With Quote