Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 272
Default Excel to Word for Newspaper

I have an excel spreadsheet - a one column list (few hundred lines). I have
to get it into a Word document and have it continuously word wrap the lines
into one big paragraph for printing in a newspaper. I know there has to be
an easy way to do this but can't figure it out.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default Excel to Word for Newspaper

Copy your Excel table to Word, the Excel text gets inserted as a table.

Select the entire table and click TABLE in the Word menu and select CONVERT,
TABLE TO TEXT.

Format the converted table text for columns and then move the insertion
point to the end of the last column and click INSERT in the menu, select
BREAK and click the CONTINUOUS option button. Click OK to exit.

Inserting the continuous section break will balance your table columns
--
Kevin Backmann


"lori" wrote:

I have an excel spreadsheet - a one column list (few hundred lines). I have
to get it into a Word document and have it continuously word wrap the lines
into one big paragraph for printing in a newspaper. I know there has to be
an easy way to do this but can't figure it out.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 272
Default Excel to Word for Newspaper

It isn't wrapping the text as one continuous paragraph. It is keeping it by
individual lines.

"Kevin B" wrote:

Copy your Excel table to Word, the Excel text gets inserted as a table.

Select the entire table and click TABLE in the Word menu and select CONVERT,
TABLE TO TEXT.

Format the converted table text for columns and then move the insertion
point to the end of the last column and click INSERT in the menu, select
BREAK and click the CONTINUOUS option button. Click OK to exit.

Inserting the continuous section break will balance your table columns
--
Kevin Backmann


"lori" wrote:

I have an excel spreadsheet - a one column list (few hundred lines). I have
to get it into a Word document and have it continuously word wrap the lines
into one big paragraph for printing in a newspaper. I know there has to be
an easy way to do this but can't figure it out.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default Excel to Word for Newspaper

When you converted the table to text I'm assuming you used paragraph marks as
the cell break in the conversion. If that's the case you'll have to remove
the paragraph mark from the end of each line.

Click the Show/Hide button (the one with the following symbol ΒΆ) to display
all the paragraph marks, it will be easier to find them that way.

Move to the end of each line and delete each one, adjusting spacing as you go.

Not knowing how many columns you've copied over or what type of text you're
working with makes it a difficult to suggest another method.

If that's the case
--
Kevin Backmann


"lori" wrote:

It isn't wrapping the text as one continuous paragraph. It is keeping it by
individual lines.

"Kevin B" wrote:

Copy your Excel table to Word, the Excel text gets inserted as a table.

Select the entire table and click TABLE in the Word menu and select CONVERT,
TABLE TO TEXT.

Format the converted table text for columns and then move the insertion
point to the end of the last column and click INSERT in the menu, select
BREAK and click the CONTINUOUS option button. Click OK to exit.

Inserting the continuous section break will balance your table columns
--
Kevin Backmann


"lori" wrote:

I have an excel spreadsheet - a one column list (few hundred lines). I have
to get it into a Word document and have it continuously word wrap the lines
into one big paragraph for printing in a newspaper. I know there has to be
an easy way to do this but can't figure it out.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 7, paste linked to word becomes black when word pdf'd Surffreak Excel Discussion (Misc queries) 0 June 1st 08 12:17 AM
Copy from Word to Excel, and retain indent, plus word wrap Eric Excel Discussion (Misc queries) 1 March 9th 07 03:15 AM
printing worksheet in newspaper columns Gayla Excel Worksheet Functions 1 September 8th 06 08:39 PM
Can you print xcel in "newspaper colmn" fashion? Joe Setting up and Configuration of Excel 5 August 3rd 06 05:35 PM
Newspaper layout using Excel? adgal Excel Discussion (Misc queries) 1 December 29th 05 05:58 PM


All times are GMT +1. The time now is 07:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"