excel - Check to see if cell contains 2 spaces directly after each other -

excel - Check to see if cell contains 2 spaces directly after each other -

is there way can check see if cell contains 2 spaces after 1 another?

for illustration if cell contained "the cat went meow" formula below homecoming "no" because there 1 space between each character. however, if there 2 spaces like

"the cat went meow"

then formula homecoming "yes".

i have tried next formula picks spaces instead of want do. can please show me how right this?

=if(isnumber(search(" " & " ",b1)),"yes","no")

your code works me as-is. simplify this:

=if(isnumber(search(" ",b1)),"yes","no")

to avoid error-checking, compare string version double-spaces converted spaces, this:

=if(substitute(b1," "," ")<>b1,"yes","no")

but i'm unsure problem you're having existing code.

excel