how to filter for begin of text string
 

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

how to filter for begin of text string
 

IF(Left(B1,2)="CR", your results

Not sure what P is.. P1?

Then, P1="HQ",P1="OC")

"ttp" wrote:

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

how to filter for begin of text string
 

Hi

Is this a formula question? If so then:

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

Richard


"ttp" wrote in message
...
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

how to filter for begin of text string
 

one way

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


"ttp" wrote in message
...
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