View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Using "*" and "#" in If statements

=if(left(b2,1)="b","starts with B","doesn't start with B")
or
=if(countif(b2,"B*")0,"starts with b","doesn't start with b")

Eric wrote:

I am trying to write an if statement to return a TRUE for any cell with a
string of text starting with "B". Was thinking something like
if(B2="B"&***,B2,"") but I don't know the proper syntax for the B***.

Any thoughts are appreciated.

Thanks


--

Dave Peterson