E
Erik Wikström
Currently I'm working on something where I have to copy data from a
website into Excel 2007, the data is usually a row (or a few columns of
the row) from a large table on the site. The problem I'm running into
(and have ran into when doing other things too) is that by default Excel
chooses to paste the selected text as HTML (I presume) which means that
all the data is pasted into one cell, while I want each column from the
table to go into a column in Excel. To accomplish this I need to select
Paste Special and then unformatted text (or Unicode text).
So I'm wondering, since I almost never want to paste as HTML, but rather
prefer pasting as unformatted text, if there is a way to change the
default pasting mode to unformatted text.
website into Excel 2007, the data is usually a row (or a few columns of
the row) from a large table on the site. The problem I'm running into
(and have ran into when doing other things too) is that by default Excel
chooses to paste the selected text as HTML (I presume) which means that
all the data is pasted into one cell, while I want each column from the
table to go into a column in Excel. To accomplish this I need to select
Paste Special and then unformatted text (or Unicode text).
So I'm wondering, since I almost never want to paste as HTML, but rather
prefer pasting as unformatted text, if there is a way to change the
default pasting mode to unformatted text.