|
|
Test to see if cell contains a space?
It'll return a yes, if the cell contains a space.
Ideas?
Thank you.
Rick
|
|
0
|
|
|
|
Reply
|
 Rick
|
12/21/2009 6:16:26 PM |
|
If(A1=" ","Yes","No")
"Rick" <rickyhalding@gmail.com> wrote in message
news:c95c23b4-0936-4938-a781-4e377fdf9393@j19g2000yqk.googlegroups.com...
> It'll return a yes, if the cell contains a space.
>
> Ideas?
>
> Thank you.
> Rick
|
|
|
0
|
|
|
|
Reply
|
Otto
|
12/21/2009 6:22:24 PM
|
|
One way...
=IF(COUNTIF(A1,"* *"),"Yes","No")
--
Biff
Microsoft Excel MVP
"Rick" <rickyhalding@gmail.com> wrote in message
news:c95c23b4-0936-4938-a781-4e377fdf9393@j19g2000yqk.googlegroups.com...
> It'll return a yes, if the cell contains a space.
>
> Ideas?
>
> Thank you.
> Rick
|
|
|
0
|
|
|
|
Reply
|
T
|
12/21/2009 6:26:11 PM
|
|
On Dec 21, 12:26=A0pm, "T. Valko" <biffinp...@comcast.net> wrote:
> One way...
>
> =3DIF(COUNTIF(A1,"* *"),"Yes","No")
>
> --
> Biff
> Microsoft Excel MVP
>
> "Rick" <rickyhald...@gmail.com> wrote in message
>
> news:c95c23b4-0936-4938-a781-4e377fdf9393@j19g2000yqk.googlegroups.com...
>
>
>
> > 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
|
|
|
0
|
|
|
|
Reply
|
Rick
|
12/21/2009 6:38:51 PM
|
|
|
3 Replies
1413 Views
(page loaded in 0.107 seconds)
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
4936 articles. 
39 followers. 