EXCEL help

[kir]

i would like to know how to:

IF in cell b1 I type Janet, c1 I type a, how do I get go about:

Printing the content of cell b1(which is "Janet") in e.g cell F1 whe
c1=

 

[Del]

In cell F1 put the formula

IF(c1="a",b1,"")

 

[kir]

thanks Del

This has solved my first problem


Howver I have got another problem

Instead of typing a in C1 I type ab and I still want it to Print b
(which is Janet) if c1 has the letter a in it as part of ab.

Any ideas

 

[Bob Phillips]

=IF(ISNUMBER(FIND("a",C1)),B1,"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[kir]

I have tried the formula below

=IF(ISNUMBER(FIND("a",C1)),B1,"")

But it is not printing anything at all (the cell B1), I have even trie
to use wild card with the "*a*" without getting it to print cell B1

Any help is most welcomed

 

[JE McGimpsey]

FIND is case sensitive - does your Text in C1 really contain a lowercase
"a"?

Note that FIND doesn't allow wildcards.

 

[kir]

Problem was the case sensitive.

Working now. Great!!

Thanks al