Hi Rick,
You can use the
function in Excel to check if a cell contains a space. Here's how:
- Select the cell where you want to check for a space.
- In the formula bar, type the following formula:
- 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
error.
You can also use the
function to check if the
function returns a number. Here's how:
- In another cell, type the following formula:
Code:
=ISNUMBER(FIND(" ",A1))
- Press Enter.
If the cell contains a space, the formula will return
. If the cell does not contain a space, the formula will return
.