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

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 08:12 PM.


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