Excel 2007 and Paste Special with HTML and data from the web
Hello,
In previous versions of Excel, if one pasted data in from an HTML table
(i.e. a paste from a web page), it would maintain the formatting, etc. In
Excel 2007, it pastes everything into a single cell as text.
Is there anyway to fix this?
Does anyone have an explanation as to what / why this is happening?
Thanks
|