View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mstack
 
Posts: n/a
Default copy and paste between cells that have data

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?