On Fri, 18 May 2012 19:28:18 +0100, mouser wrote:

(Sorry - what is difference between 3rd and 4th example - what is active cell
in 3rd - or do you mean Word ?)

In third example, I have an active cell selected. E.g. I navigate to A1, and then paste. Each line in the source goes into a separate row of the workbook.

In fourth example, I select A1 and then place cursor in the function bar (above the worksheet proper), and then "paste". All of the source goes into A1.