Using "*" and "#" in If statements
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
|