Copy the contents of a cell in excel to another cell

  • Thread starter Thread starter 27Jack
  • Start date Start date
2

27Jack

I have an excel 2007 spreadsheet. I have colums set-up with last_name,
first_name, address (etc). I would like to take the first name from one row
and add it in to the first_name cell of another row.

Example

John | Doe
Jane | Doe

What I would like to have is:

John & Jane | Doe

Any help??
 
Ok... I see how that works... but I need another column/cell to that in.

Is there a way to do it as a macro?

I have over 10,000 rows to go through, and combine names.

TY!
 
Back
Top