View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
27Jack 27Jack is offline
external usenet poster
 
Posts: 6
Default Copy the contents of a cell in excel to another cell

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??