Contains

[lehigh]

Hi All:

Is there a formula or a conditional format which askes if a cell
contains a certain letter or word?

For example;

The contents of A1 is JOE, PETE, HARRY, MIKE
(all in the same cell)

The contents of B2 is PETE

How would you write a formula in C2 to ask if B2 is contained in A2?

Thanks for your help


Tom Snyder

 

[Paul]

Hi All:

Is there a formula or a conditional format which askes if a cell
contains a certain letter or word?

For example;

The contents of A1 is JOE, PETE, HARRY, MIKE
(all in the same cell)

The contents of B2 is PETE

How would you write a formula in C2 to ask if B2 is contained in A2?

Thanks for your help


Tom Snyder

=ISNUMBER(FIND(B1,A1))

 

[David Hager]

=FIND(B2,A2) will return a number if the item is found and an error if it is
not.