Thread: Test to see if cell contains a space?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Test to see if cell contains a space?
One way...

=IF(COUNTIF(A1,"* *"),"Yes","No")

--
Biff
Microsoft Excel MVP


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

Ideas?

Thank you.
Rick


Reply With QuoteReply With Quote