I have received a spread sheet with 1600 rows. The columns are set up as follows
with a couple of data entries.

A B
LastName FirstName
Smith John
Jones (now Brown) Betty

I am going to insert a column between A & B and call it MaidenName What I would
like to know if there is a way through VBA (which I know nothing) to remove the
(now) and leave that name in Col A (LastName) and move the old last name into
the Maiden Name column as below.

A B C
LastName MaidenName FirstName
Smith John
Brown Jones Betty

Would hate to have to do this on a case by case basis, and any help will as
usual be greatly appreciated, as this will be an on going project.

--

Regards
Michael Koerner