Excel to Word for Newspaper

L

lori

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.
 
K

Kevin B

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
 
L

lori

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

Kevin B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top