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

Question is not clear,
Could you please repost it clearly?

"Zeeshan Zaheer" wrote:

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Naveen" wrote:
Question is not clear,
Could you please repost it clearly?

"Zeeshan Zaheer" wrote:

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

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


"Zeeshan Zaheer" wrote:

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