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

Ideas?

Thank you.
Rick

Hi Rick,

You can use the

Code:

FIND

function in Excel to check if a cell contains a space. Here's how:

1. Select the cell where you want to check for a space.
2. In the formula bar, type the following formula:
   Code:

   =FIND(" ",A1)

3. Press Enter.

If the cell contains a space, the formula will return the position of the space in the cell. If the cell does not contain a space, the formula will return the

Code:

#VALUE!

error.

You can also use the

Code:

ISNUMBER

function to check if the

Code:

FIND

function returns a number. Here's how:

1. In another cell, type the following formula:
   Code:

   =ISNUMBER(FIND(" ",A1))

2. Press Enter.

If the cell contains a space, the formula will return

Code:

TRUE

. If the cell does not contain a space, the formula will return

Code:

FALSE

.

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

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

Ideas?

Thank you.
Rick

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

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