#1
|
|||
|
|||
Putting text to Excel
I need help. I have A LOT of word files that I need to put into Excel. But heres the problem, they didn't use a table. They used tabs.
If anyone could help me with some tips on doing this it would be great. There are so many I have to do! I uploaded the file on here so you guys can see what the problem is. I need to get the first column of number into a column in Excel. |
#2
|
|||
|
|||
Quote:
What you need to do is 1 of 2 things. you need to paste the data into excel. If it does not separate into columns use the text to columns feature. If that does not work we can look at another option but this one should work fine. |
#3
|
||||
|
||||
Hi Leandro,
Basically what you'll need is a macro that goes through all the Word files, extracts the data, then outputs it to Excel (either directly or via text files) where it can be separated into columns. From looking at your attached document, it appears the first 'column' might in fact be common to all files and could serve as column headings in Excel. However, there's nothing to indicate what each of the other columns is for or to differentiate one file's contents from any other file's contents. You'll need to give consideration to these issues before much progress can be made. Excelledsoftware: I don't see why this should go in the Excel forum, as it involves both Word and Excel.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Putting italics back into a document | lordofscones | Word | 8 | 12-06-2011 07:54 PM |
Putting an image with hyperlink to certain slides | spiffmonkey1 | PowerPoint | 1 | 07-17-2011 03:58 PM |
Putting a bookmark on a REF field in the selection | b0x4it | Word VBA | 4 | 05-26-2011 01:14 AM |
Putting periods/dots around the letter A | ph3iron | Word | 0 | 03-27-2010 06:11 AM |
Read Receipt option on even after putting it off | ran_sushmi | Outlook | 0 | 04-17-2009 06:31 AM |