Solved

Word columns to Excel Columns

Posted on 2004-08-11
14
227 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
ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

810 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