Hi,

Data can be depicted in different lines of a cell by using Alt+Enter.  A lot of people have the doubt of how to segregate data (in diferent columns) which has been entered in a cell through Alt+Enter.  The trick here is to

1. Goto "Text to columns", 
2. Select delimited;
3. Uncheck "tab" and check "Other";
4. Now enter Alt+010 (through the numeric keypad)
5. Click Next

You will notice that the output will now be divided in 2 seperate columns.

Interestingly, some one asked me just the reverse question i.e. if data is in 2 columns, then how can it be aggregated in different lines of one cell.

The trick here is to use the CHAR(10) function.  For example, if you have A in cell A1 and B in cell B1, then in cell C1, enter =A1&char(10)&B1.  Now wrap text the cell C1 (Format cells > Alignment tab).  You will notice that C1 will have A and B in different lines.