website help needed

dipsomaniac

googler wrote: »

Select All within the webpage
Copy to clipboard
Open Notepad
Paste into Notepad
Where you want the existing data split into columns, either insert a Tab, or a suitable delimiter (I use . If it's already tabbed, fine.
Save the Notepad data as a *.txt file

Open Excel, place cursor at cell A1, open the 'Data' menu, select 'Import External Data'
Navigate to the txt file you just saved, and specify the delimiter option you used - tab or '='.
Follow the prompts, and it should import your data nicely formatted in columns.

tried doing this but the pasted data in notepad is pretty much unrecognisable from the tabulated website

Dime_Bar

Using Excel 2010 if you copy all the table including the table headings and then paste using the "Match Destinations" option then it works fine.

Lil306

"Damned with faint praise" would sum this up.

Your version didn't use the 'Import External Data' option either.

Quite correct, but it didn't work either which is what I was expecting. It was still worth a try as like you others pick up on things I miss out

Dime_Bar wrote: »

Using Excel 2010 if you copy all the table including the table headings and then paste using the "Match Destinations" option then it works fine.

Is this feature available in 2007, I don't think many people on these forums use 2010?

Dime_Bar

Lil306 wrote: »

Quite correct, but it didn't work either which is what I was expecting. It was still worth a try as like you others pick up on things I miss out



Is this feature available in 2007, I don't think many people on these forums use 2010?

I have not used 2007 for some time so not sure. Quite a few people do use 2010 as the beta is free and has been since mid last year, you can still get the beta here although it is time limited and I would have thought they will be pulling the downloads soon as it is RTM.

Lil306

Dime_Bar wrote: »

I have not used 2007 for some time so not sure. Quite a few people do use 2010 as the beta is free and has been since mid last year, you can still get the beta here although it is time limited and I would have thought they will be pulling the downloads soon as it is RTM.

Cheers, I'll D.L it and have a try

dipsomaniac

Dime_Bar wrote: »

Using Excel 2010 if you copy all the table including the table headings and then paste using the "Match Destinations" option then it works fine.

thanks. i haven't downloaded 2010 yet but i know people that have and had problems with outlook. anyone else had problems with outlook or know if you can use excel 2010 but use an older version of outlook