Does anyone know if there is a way of saying

'deleted is a string

If cell contains deleted, Deleted or DELETED (ie allowing for case
sensitivity)

Not if cell = deleted

i looked at the instr funtion but am not sure how to contruct it for
the three options.

Cheers


--
JamesBurrows
------------------------------------------------------------------------
JamesBurrows's Profile: http://www.excelforum.com/member.php...o&userid=35101
View this thread: http://www.excelforum.com/showthread...hreadid=551882