If a cell in column A contains a word like univ, I want the number 1 to appear in the respective row in column 2. If a cell in column A does not contain a word univ, I want the number 0 to appear in the respective row in column 2. Many thanks. Last edited by undergraduate; 01-29-2010 at 09:56 PM. Register To Reply.