On Dec 21, 12:26*pm, "T. Valko" wrote:
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- Hide quoted text -

- Show quoted text -

Thank you all!!!

Rick