Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy table from web site
My problem is need some data (included branch address & office address) from web site (which is table) when I paste into excel, the office address has been splited into 3 rows or more. and the branch address is fitted into 1 cell with wrap text. Actually I need to do the mail merge, how can I transpose the office address into 3 column instead of 3 row (maybe the address is more than 3 rows) And also for the branch address, how can I split it into few column instead of 1 cell thanks -- bogi_js ------------------------------------------------------------------------ bogi_js's Profile: http://www.excelforum.com/member.php...fo&userid=2475 View this thread: http://www.excelforum.com/showthread...hreadid=516805 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy table from web site
dont copy paste
in excel click data-get externaldata-new webquery in the web query window type or paste the url if you are having excel 2002 and above All the tables will have arrow indicators. click arrow of the particular table you want the arrow will turn into tick and the table will be bordered. clcik import and choose the cell from which you want it import and click ok if you are having excel 2000 you have to indicate the number of the table which can be guessed by looking at the soruce or by some trial and error. "bogi_js" wrote in message ... My problem is need some data (included branch address & office address) from web site (which is table) when I paste into excel, the office address has been splited into 3 rows or more. and the branch address is fitted into 1 cell with wrap text. Actually I need to do the mail merge, how can I transpose the office address into 3 column instead of 3 row (maybe the address is more than 3 rows) And also for the branch address, how can I split it into few column instead of 1 cell thanks -- bogi_js ------------------------------------------------------------------------ bogi_js's Profile: http://www.excelforum.com/member.php...fo&userid=2475 View this thread: http://www.excelforum.com/showthread...hreadid=516805 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy a table from a cell value? | Excel Discussion (Misc queries) | |||
Copy and Paste from Web Site | Excel Discussion (Misc queries) | |||
entering data to table | Excel Worksheet Functions | |||
I need to copy table from one sheet to anothe | Excel Worksheet Functions | |||
Pivot table copy and paste | Excel Worksheet Functions |