Test to see if cell contains a space?

[Rick]

It'll return a yes, if the cell contains a space.

Ideas?

Thank you.
Rick

 

[Otto Moehrbach]

If(A1=" ","Yes","No")

 

[T. Valko]

One way...

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

 

[Rick]

One way...

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

--
Biff
Microsoft Excel MVP






- Show quoted text -

Thank you all!!!

Rick