Test to see if cell contains a space?

Rick · Dec 21, 2009

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

Ideas?

Thank you.
Rick

Otto Moehrbach · Dec 21, 2009

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

T. Valko · Dec 21, 2009

One way...

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

Rick · Dec 21, 2009

One way...

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

--
Biff
Microsoft Excel MVP

- Show quoted text -

Thank you all!!!

Rick