By enclosing the multiple lines (carriage return separated) in quotes, Open Office calc will load the multiple lines therein into a single cell (after asking you what delimiter(s) to use and you have to unselect comma and select tab). This should work also on Excel - But I couldn't test it on the Excel 2007 I have on my corporate laptop because that version of Excel appears to have changed so that it makes no effort to find a delimiter and just loads each line of input into a single column - hence the test on OOcalc instead.
