Using "*" and "#" in If statements

E

Eric

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
 
D

Dave Peterson

=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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incorporating the User Profile location into a document template path 1
Start a mail merge upon opening the document 1
Change Style to 'Keep with previous' instead of Keep with Next 1
Page numbering with Merged Document and IF statements 1
VSTO C# add in Outlook.Appointment error 0
Formating bolded text exclusively. 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0

Top