Hi tjh

Use the =FIND function nested within an =IF function.

Your check within the IF function should look for an #N/A return from the
FIND function.

Excel's help or textbooks should explain these well.

Regards

Phil

"tjh" wrote:

Hello,

I would like cell B1 to reference cell A1, and if cell A1 contains a "N"
within the cells text (multiple characters) then I would like cell B1 to give
a particular phrase otherwise give other text.

Thanks,