Find certain text in a cell and mark it as...

[siobeh]

Hello, could anyone help me on this..

I want to search a certain text in a cell and mark it.

For example:

For Column A, if cell contains "Move" mark, it Move, else Mark it "Delete"

Ex:
A1 = contains Move B1 = Move
A2 = contains Move B2 = Move
A3 = doesnt contain Move B3 = Delete

Thanks in advance!

[tehneXus]

try

Please Login or Register  to view this content.

[siobeh]

Thanks! It's working!

[tehneXus]

just adapt the commented lines by changing the column number

Please Login or Register  to view this content.