Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-10-2009, 04:17 PM
steeleye steeleye is offline How to transfer Word 2003 Tables to Excel? Windows XP How to transfer Word 2003 Tables to Excel? Office 2003
Novice
How to transfer Word 2003 Tables to Excel?
 
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, 14 views)
Reply With Quote
  #2  
Old 07-10-2009, 04:18 PM
steeleye steeleye is offline How to transfer Word 2003 Tables to Excel? Windows XP How to transfer Word 2003 Tables to Excel? Office 2003
Novice
How to transfer Word 2003 Tables to Excel?
 
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, 17 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 Word 2003 Tables to Excel? How to transfer multiple cells from excel to word by formulas justziggy Word 5 05-23-2009 02:33 AM
How to transfer Word 2003 Tables to Excel? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft