DME Wrote:
IN cell a1 I have CP-Barge

In B1 I want a formula that says IF A1 contains CP then Enter CP into
cell
B1otherwise leave it Blank

I have tried =IF(a1="*CP*","CP","") but it does not work.

Thanks for your help

Will this work for you?

=if(left(A1,2)="CP","CP","")


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=273449