| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy the contents of a cell in excel to another cell
Hi Jack
Try =A1&" & "&A2 Regards, Pedro J. 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?? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy the contents of a cell in excel to another cell
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! "Infinitogool" wrote: Hi Jack Try =A1&" & "&A2 Regards, Pedro J. 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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I automatically copy cell contents from one cell into anot | New Users to Excel | |||
| How do I copy cell contents to footer in Excel | Excel Discussion (Misc queries) | |||
| cell function to copy contents of another cell | Excel Worksheet Functions | |||
| excel - formula to copy the cell contents and colour. Possible? | Excel Discussion (Misc queries) | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
Hybrid Mode
