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