ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copying and Pasting from Web Pages (https://www.excelbanter.com/excel-discussion-misc-queries/80350-copying-pasting-web-pages.html)

Christina

Copying and Pasting from Web Pages
 
Usually when I want data from a web page that uses Courier (fixed width)
font, I do a copy, paste special as text and use the Data|Text to Columns
command to parse it out. Sometimes, though Excel does this "on its own"; ie,
it makes an attempt to parse it out for me when I do the paste special as
text. Sometimes that's ok, but sometimes it's not -- sometimes I really do
want to parse it out using Data|Text to Columns because there's a column
break I want to change/adjust. I can't figure out why sometimes it attempts
the parsing and sometimes it does not. It usually starts to do its own
parsing after I've been playing around with copying and paste specialing a
bunch of stuff -- but I use new worksheets, where there's no "left over"
formatting from previous pastes or anything. Then, when I quite completely
out of Excel and restart it and do a copy, paste special as text, it doesn't
attempt to parse (it's like quitting "resets" it). Does anyone understand
what I mean and/or why this happens? Thanks.


All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com