MERGING CELLS WITHOUT LOOSING DATA IN THE SECOND CELL

K

kalyan

HOW TO MERGE TWO CELLS WITHOUT LOOSING THE CONTENTS OF THE SECOND ONE?IS IT
POSSIBLE ATLEAST?
 
N

NeedToKnow

I would do it to addind one column, then concatenate cells, regarding what
for and how this information is used normally. Possibly I would then copy ->
paste special -> values depending use after.

Complicated I know but I don't know other way.

Why do you want to merge them?

"kalyan" kirjoitti:
 
D

David Biddulph

Firstly, please get your Caps Lock key repaired and stop SHOUTING
Secondly, please don't merge cells, as merged cells cause many problems
(which you will see described in the archives of this group).
Thirdly, if you want to combine data, perhaps you want the CONCATENATE
function or the & operator?
 
Top