Identifying Text

[STEVEB]

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!

 

[dominicb]

Good afternoon SteveB

You need to put this formula in your first row that contains data in
column B (in this case B4) and copy it all the way down to the bottom.

=IF(ISERR(SEARCH("transf",C4)),"O","T")

HTH

DominicB

 

[STEVEB]

Dominic,

THANK YOU!!! Everything worked great! I really appreciate your help!

 

[dominicb]

Hi SteveB

No problem. Appreciate the feedback.

Dominic