copying data

  • Thread starter Thread starter Julia
  • Start date Start date
J

Julia

Hi!
I was wondering if anybody knows how to copy fast data
from one column to another (each cell contain different
data). If I merge cells I'm loosing data in one cell, but
copying one after another looks pretty dummy to me. And I
have 500 rows to go.
Thanks,
Julia.
 
When I copy it replaces what I already have in the cell,
but I need to combine information in two cells into one
cell. For example:
A B
1 33 55

I need this to be
A
1 3355

Thanks,
 
In C1, put the formula
=A1&B1
Then copy this formula down column C as far as you need. To do this, you can
select C1 and drag the fill handle (the little black square at the bottom
right of the selected cell).

If you want to keep just the results rather than the equations themselves,
you can then copy column C and use
Paste Special > Values
At this point, you can delete the original columns A and B if you wish.
 
Back
Top