How to load web page into Excel properly?
 

Does anyone have any suggestions on how to load web page into Excel properly?
when I load following page into excel
http://www.hkex.com.hk/futures/futur...090812.htm#HKB

all text is insert into cell A11, I get no idea on how to split them.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

How to load web page into Excel properly?
 

What method are you using to import the page into excel and what info do you
want.
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Does anyone have any suggestions on how to load web page into Excel
properly?
when I load following page into excel
http://www.hkex.com.hk/futures/futur...090812.htm#HKB

all text is insert into cell A11, I get no idea on how to split them.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

How to load web page into Excel properly?
 

I used copy & paste to get the block staring the ALC and ending with ZJM
into column A
Then I used Data | Text to Column with Fixed specified and got each item in
its own cell

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Eric" wrote in message
...
Does anyone have any suggestions on how to load web page into Excel
properly?
when I load following page into excel
http://www.hkex.com.hk/futures/futur...090812.htm#HKB

all text is insert into cell A11, I get no idea on how to split them.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric