On Tuesday, June 30, 2009 at 4:38:01 PM UTC+7, Jacob Skaria wrote:
If this is one cell
try
=IF(COUNTIF(A1,"*check*"),"Checking","Doing")
Since you mentioned row...try the below as well It checks for these words in Cols A to J for the first row. Copy down as required. =IF(COUNTIF(A1:J1,"*check*"),"Checking","Doing")
If this post helps click Yes
---------------
Jacob Skaria
"Eán" wrote:
I have a row containing various text including the words 'Check' & 'Checking'; in a separate row I would like to identify all the cells which include 'Check' or 'Checking' and return the text "Checking" if it contains
either 'Check' or 'Checking' or "Doing" if it doesn't.
Hope this makes sense?
Many thanks
what should I do, when I have to find 2 different texts ?
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)