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

Hi

=IF(ISERROR(SEARCH("deleted",A2)),"No","Yes")

Hope this helps.
Andy.

"JamesBurrows"
wrote in message
news:JamesBurrows.29edun_1150297806.3593@excelforu m-nospam.com...

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

Thanks for your help Andy that looks about right. A few issues I have
with it a I dont want an error message if it contains the string i
meerly want it to do the code below if it is present else, blah blah
blah. and also my cell reference is not A2 it is Worksheets("Line
List").Cells(LLCurrent, "Y"), but when i put this in it seems to cause
a massive headache.

Any help gratefully appreciated.

James


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