Paste from Word 2003 to Excel

G

Guest

When I copy text from a formatted survey type word document, and try to paste
it into an Excel spreadsheet from the same source, the text will split up and
spill into cells below it, even though the cell size is easily large enough
to hold it. Sometimes it will spill to multiple cells below it. Wrap text is
on, and I can copy and paste from cell to cell with large text and no
problems.
Appreciate any help.
Formatting appears OK, although the lines between the cells seem to lighten
when a paste is done into them.
 
J

John Spencer

This is because of paragraph breaks and tabs doing different things in the
two programs.

Try posting to one of the Excel forums and perhaps they can tell you how to
work around your problem.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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