Thanks Julie

That worked fine.

Now is it possible to check for more then one word, could I for example
check if the sentence contained "prominent" or "chased leaders" and
assign a value if it contained either of these comments

Cheers

Paul


--
paulfitz320
------------------------------------------------------------------------
paulfitz320's Profile: http://www.excelforum.com/member.php...fo&userid=6643
View this thread: http://www.excelforum.com/showthread...hreadid=278208

Hi Paul

one way
=IF(AND(ISERROR(FIND("prominent",E17)),ISERROR(FIN D("chased
leaders",E17))),"",1)
where you want the same value returned for each

Cheers
JulieD


"paulfitz320" wrote in message
...

Thanks Julie

That worked fine.

Now is it possible to check for more then one word, could I for example
check if the sentence contained "prominent" or "chased leaders" and
assign a value if it contained either of these comments

Cheers

Paul


--
paulfitz320
------------------------------------------------------------------------
paulfitz320's Profile:
http://www.excelforum.com/member.php...fo&userid=6643
View this thread: http://www.excelforum.com/showthread...hreadid=278208