Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word Tables

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-10-2009, 04:17 PM
steeleye steeleye is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2009
Posts: 3
steeleye is on a distinguished road
Default How to transfer Word 2003 Tables to Excel?


I have Word 2003 & Office 2003 SP3

I have recently finished cataloging, grading and pricing my vinyl LP record album collection, which numbers close to 1000. I used individual tables in Word 2003 for each album (see the attached file). I want to transfer all of the info. that is contained within each table to an Excel cell to create 4 Excel docs (A thru F, G thru L etc.). The trouble is, I know virtually nothing about Excel. I'm sure that it's just a matter of playing with the cell sizes but, again, I am pretty lost here. I want to keep the general look of my Word docs. Could someone please walk me thru this (baby steps please!)?
Attached Files
File Type: doc Album List Table Forum.doc (71.5 KB, 2 views)
Reply With Quote
  #2  
Old 07-10-2009, 04:18 PM
steeleye steeleye is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2009
Posts: 3
steeleye is on a distinguished road
Default

I have found that if, in Word 2003, I click Convert > Table to Text > Separate text with - Paragraph marks the resulting XLS doc. is very similar to my Word table (see attached). I have approx. 120 tables per Word doc. so it would be great if the process could be automated.
Attached Files
File Type: xls Album List VDr.xls (62.5 KB, 6 views)
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shading in Cells in Word Tables Cindy Word Tables 1 01-04-2013 02:38 PM
How to transfer multiple cells from excel to word by formulas justziggy Word 8 05-23-2009 02:33 AM
Word 2007 Password not staying after file transfer. grumalt Word 1 04-17-2009 12:30 PM
Copying tables between Word documents best practices? dylane Word Tables 0 12-18-2008 12:21 PM
contingency tables franky_gbr Excel 0 02-18-2008 01:28 PM


All times are GMT -7. The time now is 09:32 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft