Display multiple lines of text within a cell from multiple column.

Z

Zeeshan Zaheer

actually, I want to display multiple columns information within a cell in
multiple rows. normally we use ALT+Enter to write in multiple lines in a
cell, the same way I want a formula that could display the multiple columns
in a cell but in multiple line example:

1 A B C D

2 1 1 2 3
2
3
3
 
M

Max

Hazarding a guess ..

Put something like this in A2:
=B2&CHAR(10)&C2&CHAR(10)&D2
then format A2 to wrap text (via: Format > Cells > Alignment tab)
... then copy A2 down if/as required
 
M

Muhammed Rafeek M

Hi Try this one
B2-1
C2-2
D2-3

in A2-
=A1&"
"&B1&"
"&C1

Note: between "" enter 'Alt+Enter'. you can just copy above function and
paste to A1. Once you done, active 'wrap text' from format cell menu.

if it is helpful, then pls rate
 
Top