Solved

Word columns to Excel Columns

Posted on 2004-08-11
14
230 Views
Last Modified: 2012-06-27
I need to transfer hundred of pages of 2 column text from Word to Excel into 2 side by side columns.   The look would be exactly the same, but how can this be done?

Thanks
0
Comment
Question by:lehman6676
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +5
14 Comments
 
LVL 11

Expert Comment

by:ajaikumarr
ID: 11780554
Hai,

Check this article... The exact thing which you required.
http://www.pcmag.com/article2/0,1759,1618988,00.asp

Bye
Ajai
0
 
LVL 11

Expert Comment

by:ajaikumarr
ID: 11780588
Hai,

Or you can drag the columns in word and then drop it on excel will do.

Bye
Ajai
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 9

Expert Comment

by:tosh9iii
ID: 11781066
Copy and Paste it, after that, there should be a small clipboard near the bottom right of the data, click on it and select "Match destination formatting"
0
 

Author Comment

by:lehman6676
ID: 11783561
The problem is that my data is not in a table and not physically columnar data.  It is sequential data which is formatted on the screen as columns.  That's where I'm having trouble.  I want the same look in Excel as in Word, but the internal format has to change along the way from sequential text to columnar text.  I can write a vb program to do it, but I was hoping there was an easier way.

Thanks
0
 
LVL 6

Expert Comment

by:nomi17
ID: 11787806
In your word doc, is the data merely separated with a tab to create the look of columns?
0
 

Author Comment

by:lehman6676
ID: 11789158
No.  I just set up the page to be viewed and printed as columns.  It happens to be that the columns line up exactly so that the side by side text is related.  That's not typically the case with regular columns such as a magazine article.

Thanks
0
 
LVL 33

Expert Comment

by:Jeroen Rosink
ID: 11791459
you might think about using another texteditor as workaround.
in textpad you can select data in blockmode (http://www.textpad.com)

so if you copy the data from word into textpad and you turn on the select block mode option you are able to select the column of data you need and then copy it and past it into excel.
do this also for the other column.

cheers!
Jeroen
0
 
LVL 6

Expert Comment

by:nomi17
ID: 11792021
You could try to save the word doc as a plain TXT doc, the open the word doc in excel.  You will then
get the Text Import Wizard dialog box to identify coma or delimited or fixed width.  This may allow you
 to separate your data in this fashion.
0
 
LVL 3

Expert Comment

by:motaz_mohamed
ID: 11803509
1) Copy the data from your Word document.
2) In Excel choose Edit > Pate Special and then choose Text
3) One of two things will happen:
    a) Either the data will be pasted correctly in colums, then you will not need to do any further steps.
    b) All of the data will be pasted in the first column. In this case choose Data > Text to Columns and follow the wizard to convert your text from a single column to the desired columns.
0
 
LVL 7

Expert Comment

by:Etircet
ID: 12031191
Are you able to convert the word data to table?  If so you shouldn't have a problem copy and pasting the table into excel in the same format.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 13404102
PAQed with no points refunded (of 500)

modulo
Community Support Moderator
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question