Word wrapping and text formating, data from multiple cells

Bear with me, I will try to explain as best I can by using a simplified example.

I am trying to display the data found in a number of cells in one big (merged) cell with a line-break between each bit of information. So instance:

I have 3 rows and 3 columns with the following info:

A1 - ABC / B1 - DEF / C1 - GHI
A2 - JKL / B2 - MNO / C2 - PQR
A3 - STU / B3 - VWX / C3 - YZ

Now what I would like is for the above data to be displayed in cell E1, lets say, in the following manner:

• ABC
• DEF
• GHI
• JKL
• MNO
• PQR
• STU
• VWX
• YZ

Hopefully that makes sense. Thank you.

This should do the job :

Please Login or Register  to view this content.

Remember to set the formatting of your cell to wrap text.