merge adjacent cell data

R

ROLG

how do i merge a number of cells in a row so that the numbers in eac
cell will be in that one merged cell?
 
J

JulieD

Hi

you can't,
but you can concatenate them into one cell and then delete the others
=A1&B1&C1&D1 etc
will string together the values in cells A1, B1, C1 & D1
you can then copy this cell, choose edit / paste special - values to change
it from a formula to a value and then, if you want, delete the original
numbers

Cheers
JulieD
 
Top