Is there any to select all the cells which have one word

[qazxsw213]

For example
Cell A1 contains - For you to understand
Cell A2 contain -- I am
Cell A3 contains = doing
Cell A4 contain - this Thank you


In the above example, Cell A3 has only one word and the rest have more than one word. I want to select all the cells which have only one word.

Thank you

 

[Special-K99]

I dont know about "selecting" them.
But cells with one word would imply there are no spaces in the cell.
You could use this in a Helper column

in B1
=NOT(ISNUMBER(SEARCH(" ",A1)))+0
and copy down the column

1's indicate cells with one word

 

[63falcondude]

Another option would be to use Conditional Formatting to highlight all of the cells with one word (no spaces).

To do this, using your example, highlight A1:A4 > Conditional Formatting > New Rule > Use a formula

=COUNTIF(A1,"* *")=0

Format > Fill however you'd like > OK

 

[qazxsw213]

Another option would be to use Conditional Formatting to highlight all of the cells with one word (no spaces).

To do this, using your example, highlight A1:A4 > Conditional Formatting > New Rule > Use a formula

=COUNTIF(A1,"* *")=0

Format > Fill however you'd like > OK

Thanks a lot it worked

 

[qazxsw213]

Thanks

 

[63falcondude]

Great! Glad to help.