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
|