Search cell for string plus space

[Okoth]

I want to check if the value of a cell is written as 100 gram (or a different number) instead of 100gr.

Example:
100gr white sugar is wrong
100 gram white sugar is right

or

38gr cinnamon is wrong
38 gram cinnamon is right

I have tried several formulas but I'm always stuck with the space.

=SEARCH("gr *", C18 ) doesn't work
=COUNTIF(C18,"*gr *")>0 also doesn't work
=ISNUMBER(SEARCH("gr *",B18)) also not

What formula can I use to check this?

 

[Fluff]

Remove the *
=ISNUMBER(SEARCH("gr ",A2))

 

[Okoth]

Remove the *
=ISNUMBER(SEARCH("gr ",A2))

Sorry, but I have tried this before and again and it gives a FALSE.

Another example of what I don't want is

100 gr white sugar (is wrong)
100 gram white sugar (is right)

 

[Okoth]

It looks like this works

=SEARCH("gr"&CHAR(160),A2)

 

[Rick Rothstein]

It looks like this works

=SEARCH("gr"&CHAR(160),A2)

Just so you know... CHAR(160) is not a "normal" space, rather, it is a "non-breaking" space mostly used on websites to keep two words with a space between them together so they do not get split onto two different lines. You have to be careful of these when you copy text from a webpage.

 

[Okoth]

Just so you know... CHAR(160) is not a "normal" space, rather, it is a "non-breaking" space mostly used on websites to keep two words with a space between them together so they do not get split onto two different lines. You have to be careful of these when you copy text from a webpage.

Thanks for the info, Rick