Here's an "interesting" "funny" thing about pasting like this in Excel...
The choices currently "set" in the Data|Text to Columns functionality in the Ribbon change how Paste puts this data into a cell.
Select some data, even a single cell, and click in the Ribbon to start that function. The dialogue box appears and choose
Next. Now you have the list of possible delimiters Excel expects adn the ability to specify a nice "Other" if you'd like. If the only one checked is
Tab, you will be able to paste the kind of data you mention into a single cell with those individual bits on different lines in that cell, just as you wish here. If, for instance,
Space is checked, you will see the data you wanted on separate lines in a single cell broken into wholely separate cells like you show. It goes more mutli-cells, right to left, for spaces, but I've seen it go multi-line as well with internet data.
Why? Um, who knows? Surprisingly, not many even seem to have seen this either. But basically, clear ALL those checkboxes, not hard to check them again if you really DO want to do
Text to Columns, so, you know... just clear them. Then try the pasting and I'll give odds it goes just fine.
All those other approaches work too, they just require some to a LOT of extra work and other programs and so on. Use the easiest if the above does not help this time.