Test to see if cell contains a space?
 

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

Ideas?

Thank you.
Rick

Answer: Test to see if cell contains a space?
 

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

---

.

Test to see if cell contains a space?
 

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

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

Ideas?

Thank you.
Rick

Test to see if cell contains a space?
 

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

Test to see if cell contains a space?
 

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