Solved

Word columns to Excel Columns

Posted on 2004-08-11
14
228 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
  • 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
 
LVL 11

Expert Comment

by:ajaikumarr
ID: 11780601
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

856 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