#1
|
|||
|
|||
Convert word table to excel pastable format
I have the fun task of creating a database for a group at work that has been working off tables in a word document of all things. The format of their table is a title row at the top, a row of fields, then below that a merged cell row with a narrative. I want to move the merged cell row up with the fields so all the data is in a single row.
|
#2
|
||||
|
||||
This is actually surprisingly easy and won't need a macro. I've attached a Word document showing the steps I took to convert this layout.
Assuming your table is EXACTLY as you show and doesn't contain any cells with multiple paragraphs this will work. The steps you need to make are: 1. Edit the Cell which contains FieldName3 to add a paragraph after it so it contains FieldName3 NarrativeField 2. Select the entire table and Convert Table to Text, separate text with paragraph marks 3. While that text is selected, Convert Text to Table, 4 columns & separate text at Paragraphs I've attached a doc showing the dialog box settings you need to use. If you do have cells with multiple paragraphs, you need to temporarily replace them with something else eg Find and replace ^p with xxx. After you recreate the table and paste it into Excel, do the reverse search and replace (Hint: In Excel, a return in a cell is Ctrl-J in the replace box).
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Thank you very much.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Convert table of contents to table format and preserving dynamic property of fields | laith93 | Word VBA | 3 | 12-10-2021 03:22 PM |
VBA convert to table - format Column 1 | Shelley Lou | Word VBA | 4 | 01-29-2021 05:44 AM |
Convert word file into more readable format to paste into Excel | jeffreybrown | Word | 8 | 02-27-2018 05:34 AM |
Importing Data from Excel - Format of table messed up in Word Table | epsulliv | Word Tables | 6 | 08-24-2015 07:29 AM |
Excel convert format [h]:mm:ss to decimal | gchan2000 | Excel | 1 | 08-17-2010 01:36 PM |