?
Solved

Word columns to Excel Columns

Posted on 2004-08-11
14
Medium Priority
?
234 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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

765 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