I have a column of cells with text strings. I need to match a word
that matchs part of that string and call it out
Using FIND just finds a string and gives the location of the 1st
letter:
E.g
cell D4 = High Pressure Disk
cell C4 is FIND("Disk",D4) equals 15

I need to check if the string "Disk" is in the string and either give a
specific value or the name "Disk"
An IF statement would work as well, except I believe the IF statements
only work with numbers

Anyone have any thoughts?

Thanks


--
ricxl
------------------------------------------------------------------------
ricxl's Profile: http://www.excelforum.com/member.php...o&userid=32412
View this thread: http://www.excelforum.com/showthread...hreadid=521909