Does anyone have any suggestions for identifying text in a cell.

For example, I have a spreadsheet with approximately 50 to 100 rows:

Column A: $640
Column B: "Blank"
Column C: Transferred on September 1, 2005.

I would like to identify any cell in column C with the word "transfer"
or "transferred" within the cell and put a "T" in the same row of
column B, if not put a "O" in column B.

Is this posssible?

Any help would be greatly appreciated!


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=469509