Tip: Pasting Text from Internet to Excel

Hi All,

I have just solved a query I posted on the Excel General forum.

If you want to paste text data from the internet to excel, the internet provider you use makes all the difference.

If you use Internet Explorer, your data will end up in one excel column only, which will make it difficult to do calculation work.

If you use Firefox or Google Chrome, your data will spread out over a number of columns making it much easier to calculate on.

For more details, see below original query. (Read entries 1 and 9).

I hope someone finds this of use.

http://www.excelforum.com/excel-gene...ml#post3511064

If You want to paste text from internet to excel then You need to latest version of excel to manage it.

Isn't it just? This drove me mad all the time when copying from SSMS until I realised that at some point I'd used a random delimiter in ext to Columns