how to filter for begin of text string

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
 
S

Sean Timmons

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

Not sure what P is.. P1?

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

Richard Schollar

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
Macro to Select text from a point given to a specific word 2
Need help modifying code 0
Publisher crashes changing format of paragraph in Selection Textrange. 0
Issue with Find 5
VBA - exporting serial letters to single documents 0
Hide text in MSWord 2013 using macro 1
Counting the number of unique values in a filtered list 5

Top