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 |
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 |