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
 

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

Comparing a list of Records 3
Compare Another Field of Duplicate Records 5
VBA: How can I use a string variable as autofilter criteria? 4
Issue with Find 5
Counting the number of unique values in a filtered list 5
Conditional Format VB Code for Begins With 5
How do I filter or search mulitple for text strings? 2
Extract from the beginning of a text string 2

Back
Top