You're not missing anything!
It's me who's missing brain power.<g

Funny how that power of suggestion can throw you off.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Bob Phillips" wrote in message
...
Why? FIND finds it wherever it is (as does SEARCH). The OP used wildcards,
but I don't see that makes it a requirement. Am I missing something?

--

HTH

RP

"RagDyer" wrote in message
...
The problem with using FIND() in this scenario though Bob, is that it
*doesn't* accept wild cards, and to meet the OP's specs, wildcards *are*
necessary.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Bob Phillips" wrote in message
...
If you want it case-sensitive, amend RD's formula to
=IF(ISERR(FIND("CP",A1)),"","CP")

--

HTH

RP

"RagDyer" wrote in message
...
Try this:

=IF(ISERR(SEARCH("*CP*",A1)),"","CP")

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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