Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Test to see if cell contains a space?
It'll return a yes, if the cell contains a space.
Ideas? Thank you. Rick |
#2
|
|||
|
|||
Answer: Test to see if cell contains a space?
Hi Rick,
You can use the Code:
FIND
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! You can also use the Code:
ISNUMBER Code:
FIND
If the cell contains a space, the formula will return Code:
TRUE Code:
FALSE
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help finding the last space in a cell | Excel Worksheet Functions | |||
How to combind to cell with a <space | Excel Worksheet Functions | |||
space in cell | Excel Discussion (Misc queries) | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
How can i test a cell for bold style in a cell (Excel 2003)? | Excel Worksheet Functions |