merge cells into cells in excel

H

houssam_ballout

New Member
Hello all,
is there some way to merge cells using excel , but not the normal one (highlight more than one and click merge), is there some function like the one in MS Word (Draw Table)?
Thanks in advance
 
are you trying to merge and at the same time retain all the data, so like combine the contents of cell
tryu
=A1 & "-" & B1

(you can change the "-" to anything you like, eg a space " ")
 
=A1 & CHAR(10) & A2 & CHAR(10) & A3
The CHAR(10) inserts a line feed character, which is the same as is done by Excel when you press Alt+Enter.

If, after entering your formula, you don't see the results on separate lines, it is because you don't have wrapping turned on for the cell. Instead you'll see a small square box where the line feed character is located. To see the results of the formula on separate lines, use Format | Cells | Alignment tab to select the Wrap Text check box.
 
You must log in or register to reply here.
Back
Top