how to filter for begin of text string

  • Thread starter Thread starter ttp
  • Start date Start date
T

ttp

I'm trying to create a simple filter to return a specific text statement if
the variable begins with 'CR'. EXCEL is returning false when I believe the
statement is true. Please help me see my error.

If(B1 = "CR*), then P = HQ else P = OC
 
Hi

Is this a formula question? If so then:

=IF(LEFT(B1,2)="CR","HQ","OC")

Richard
 
Back
Top