Hello everyone!
I am trying to manipulate data in a range of cells in
Excel using a macro.

I need to have the macro search through a column and
verify the data in each cell.

For example, cell A1 has value of "Joe", cell A2 has
value of "Jim D". I need the macro to return A1 with
value of "Joe"(no changes there) and A2 returns a value
of "Jim".

How can I achieve that?
Thanks for advance for your help.
Consuelo :-)