IMPORT DATA FROM WEB - WON'T DOWNLOAD SPECIAL CHARACTERS

  • Thread starter Thread starter Sacs
  • Start date Start date
S

Sacs

I have a site that use a strikethrougt on certain names , however when I
download the data through the Import Data feature ... it does not download
the strikethrough ... why is it I'm able to get * characters or others and
not any kind of formatting I am using Excel 2003 . Is this possible with
2007?

This is the webpage I download from
http://league1.protourfantasygolf.com/weekly_results

Any help would be greatly appreciated
 
As the name suggests, it imports data not formatting...

If you right-click on any webpage and choose View Source (in Internet
Explorer) you will see that even there data is separate from formatting... I
mean strikethrough is applied to data (text), data itself does not have
formatting...

You can format the cells/columns after import as per your requirement...

or may try cutting and pasting... which retains most of the formatting...
 
Thank You Sheeloo but copy pasting does not work ... I wonder if in Excel
2007 your able to get actual formating of the web page do you know .. I
really need a solution.
 
There is no simple way...

I have done this for you...
Download the file from
http://wikisend.com/download/474484/weekly_results.xls

Here is what I did;
Saved the webpage as an HTML file
Opened in Notepad
Searched for
"FirstRoundStartDropped">
and replaced with
"FirstRoundStartDropped">!
(since this is what was putting the strikethrough...)
Opened the file in Excel
Deleted top few rows
Used conditional formatting to strikethrough the cells having '!'

You may come up with a shorter or easier method...

If you don't like ! then you may write a macro which removes it and formats
the cell with strikethrough
 
Back
Top