Paste Special - Text

Hi guys,

I'm trying to create a sheet that extracts names from this page- http://www.europeantour.com/european...mes/index.html

When I paste special>text, I sometimes get different results (see attached two sheets). I have written a macro that extracts and manipulates the names when pasted as shown in the 'Correct' sheet, but sometimes it pastes text strings into separate columns when I've selected the same area, and I cant think of any reason why the paste special>text would behave differently in apparently identical scenarios.

Any ideas would be much appreciated.
Thanks
Scott