copy and paste between cells that have data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to copy and paste values to a cell that already has data in it.
For example: Cell A1 has "Mary" in it. I need to paste "-1234" next to her
name so I see "Mary-1234" in cell A1. The pasted value will change for each
name in column A and I have 300 cells to go through! Right now, I'm going up
to the formula bar, putting my insertion point next to "Mary" and pasting the
value. Is there a way faster method of doing this so I don't have to
copy/paste individual cells?
 
Try pasting the values in an adjacent column and then put a simple formula as
"=G23&"-"&H23" Where G23 is the cell which contains Mary and H23 is the
adjacent cell that contains 1234 When you have it you may paste it as values
before deleting the other two columns
 
You must log in or register to reply here.

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

Multiple Numbers in a cell 3
want to track time while paste value in multiple column of same roe 1
Excel Data pastes into 2 cells not 1 1
Copy columns, but not hidden ones 3
Copy Paste 2
recall cell value in hyperlink 2
Copy formula with row automatically modified not column 5
Can't Copy and Paste in Excel 2003 0

Back
Top