Let's say your column of data is Column A. In Column B enter the formula:
=IF(ISERROR(SEARCH("base",A1)),"","X")
Copy the formula down Column B as needed.
HTH,
Elkar
"jerredjohnson" wrote:
I have a column that has words in each cell. I want to search through
the column and for any cell containing the word 'base' i want to place
an X in the cell next to it.
How can I do this?
Please help!
Thanks,
Jerred
--
jerredjohnson
------------------------------------------------------------------------
jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236
View this thread: http://www.excelforum.com/showthread...hreadid=550489