Excel formula to look for '??' or 2 seperate '?' characters

[Roy_Excel_Island_Apps]

Hi guys,

anyone who knows a formula to give a true/false output if cells countain double question marks or two seperate questions marks?

This should be the result:

[TABLE="width: 500"]
<tbody>[TR]
[TD]H?eLlo?[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]Good?night[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]Goodmorning??[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]?Goodevening[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]B??ye[/TD]
[TD]True[/TD]
[/TR]
</tbody>[/TABLE]

 

[njimack]

=len(a1)-len(substitute(a1,"?",""))=2

 

[GR00007]

=if(len(a2) -2 = len(substitute(a2,"?","")),true,false)

 

[Mike Blackman]

Or alternatively:

=ISNUMBER(MATCH("*~?*~?",B2,0))

 

[njimack]

Or alternatively:

=ISNUMBER(MATCH("*~?*~?",B2,0))

I like this solution, but it doesn't work for 2 consecutive question marks.

 

[arthurbr]

Strange, works perfectly for me
Try adding an extra asterisk =ISNUMBER(MATCH("*~?*~?*",B2,0))

 

[steve the fish]

I like this solution, but it doesn't work for 2 consecutive question marks.

Nor would it for more than 2.

 

[Mike Blackman]

Dang it, I missed an asterisk on the end - thanks arthur.

Steve - as a question mark is a character the asterisks (with the additional one mentioned) encapsulate the additional ones and it will work on as many as you could ever want.

 

[arthurbr]

Nor would it for more than 2.

I tried it with more then 2 and it works for me

 

[steve the fish]

If there are more than 2 i get true. The opening post said 2 not more than 2 didnt it?