#1
|
|||
|
|||
How to convert document columns to excel spreadsheet
Hi,
I've been asked to convert the attached word document to an excel spreadsheet based on the cells in the word doc. I've been trying to do this for the last couple of days without any success, really appreciate any help you can give. Thanks David |
#2
|
||||
|
||||
There's nothing about your attachment that suggests the table can't be converted to Excel by simply copying the entire table and pasting it into Excel. The only complication you might have is that some of your table's cells contain paragraph breaks, which will result in extra rows being created in Excel. If you don't want that, replace the paragraph breaks (using Find/Replace in Word) with something else (e.g. |) before copying. Then, after pasting into Excel, replace that 'something else' (using Find/Replace in Excel) with line breaks.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for your help Paul,
I was ignorant about replacing the paragraph symbol which obviously was my problem. This is the beauty of internet you can ask the whole world. Thank you David |
Tags |
columns, doc, excel 2016 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel spreadsheet as a data source stored within a word document | slaycock | Word VBA | 0 | 03-19-2017 11:36 AM |
Convert csv document to excel, format date | coba | Excel Programming | 3 | 01-07-2016 04:18 AM |
Find and replace in word document repeated for every item in excel spreadsheet | Daniell | Word | 1 | 02-17-2015 04:38 AM |
Convert Spreadsheet to Database Table | mebjen | Excel Programming | 1 | 11-15-2013 11:21 PM |
Macro to copy specific columns in Excel from another spreadsheet | KD999 | Excel Programming | 1 | 07-20-2012 08:58 AM |