IF Question and Conditional Format

[Mister H]

Hi All:

I am hoping for some guidance

I am looking at a report that I have put into Excel and I want to wittle it donw by identifying some things I need (or don't). Is there a way to put a Wild Card in an IF Statement?

In cell A1 I want to put the formula:

IF cell B1 STARTS WITH OPS Op then mark A1 with the word DELETE
IF cell B1 STARTS WITH Cust Name: then mark A1 with the word KEEP

I am not sure on how to go about this. Any suggestions?

THANKS,
Mark

 

[rallcorn]

Formula in A1 (copy down in Col A)
=IF(LEFT(B1,6)="Ops Op","DELETE",IF(LEFT(B1,9)="Cust Name","Keep",""))

 

[Mister H]

THANKS rallcorn

That seems to work and I think I can modify it to fits some other requirements that may arise

Have a GREAT night,
Take Care,
Mark