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

.