Copy the contents of a cell in excel to another cell

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

27Jack

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for adding text from one cell to another cell 6
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Change the colour of a neighbouring cell 6
Mailing list 0
Split cells next to 1 cell 1
Copy one cell to another 5
Dup check 2 columns - need it to delete correct one 5
Searching for specific name on main sheet then copying row data associated with name 7

Top