If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Export Word Table to Excel
Best way to do this? The Word table is growing and now the user wants to
work with it in Excel. I don't want to end up with a lot of merged cells in Excel (there are carriage returns in the individual columns that Excel sees as separate cells). Any and all ideas will be appreciated. Thanks. -- Alice. |
#2
|
|||
|
|||
Search for ^p (or ^l as appropriate) in the table and replace with, say,
###. Then copy/paste the table into Excel, search for ###, and replace with a line break. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Alice" wrote in message ... Best way to do this? The Word table is growing and now the user wants to work with it in Excel. I don't want to end up with a lot of merged cells in Excel (there are carriage returns in the individual columns that Excel sees as separate cells). Any and all ideas will be appreciated. Thanks. -- Alice. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help! Word Table to Excel | kaleb0521 | General Discussion | 2 | September 28th, 2004 07:26 PM |
Automatically Updating Excel Data In Word Doc Inside Excel File | Business Design Architect | General Discussion | 0 | August 29th, 2004 10:55 PM |
export 1 query 5 times to 1 excel file | Mike_Walrus | Running & Setting Up Queries | 7 | June 20th, 2004 01:09 AM |
export 1 query 5 times to 1 excel file | Mike_Walrus | Running & Setting Up Queries | 0 | June 19th, 2004 02:00 AM |
Can't export calculated fields to Excel | Sharon Caspers | Setting Up & Running Reports | 0 | May 26th, 2004 08:31 PM |