Contains

  • Thread starter Thread starter lehigh
  • Start date Start date
L

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
 
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
Click to expand...

=ISNUMBER(FIND(B1,A1))
 
Back
Top