Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2010, 12:19 AM
Anirudh_Dsp Anirudh_Dsp is offline extracting data from Table to text file Windows 7 extracting data from Table to text file Office 2010 (Version 14.0)
Novice
extracting data from Table to text file
 
Join Date: May 2010
Posts: 1
Anirudh_Dsp is on a distinguished road
Exclamation extracting data from Table to text file

i've got an MS word file with a table containing numerical data to be used in a Matlab code. when i try to paste the table in a text file, all the rows are being converted into columnsand each column is appearing below the previous one. I found out that this was because the entries in the table were all written in a single row, i.e., around 22 readings in each column but all are written in the same row, in the same cell. Is there anyway to seperate the data in each row into 22 rows each containing one of the readings? please reply Asap... thank you!!!
Reply With Quote
  #2  
Old 05-23-2010, 07:48 AM
Kimberly Kimberly is offline extracting data from Table to text file Windows 7 extracting data from Table to text file Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

I created a table that is one row but several columns and placed multiple paragraphs in each cell to somewhat replicate what you have. I discovered that neither Convert to Text or Convert to Table did anything good.

You can use the Draw Table tool (find it by clicking on the Table tool on the Insert tab) to draw in the missing rows. Be sure you have View Gridlines turned on (Layout tab).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost Data file after trying to set Exchange account david shaw Outlook 0 04-07-2010 05:28 AM
Excel file lost data how to recover it zillah Excel 1 02-10-2010 08:36 PM
extracting data from Table to text file Formatting text in a table of contents newbie Word 1 12-28-2009 02:48 AM
Trying to merge label data from file ClayShannon Mail Merge 0 09-16-2009 10:08 PM
table text overlap zaqtivi Word Tables 4 05-22-2009 12:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:04 AM.


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