LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default Copy from Word to Excel, and retain indent, plus word wrap

I've got some text in Word 2003, formatted using Word's standard outline
indent formatting.

(This is a standard Word format, in which Word formats the text as a series
of paragraphs (multi-line text), in hierarchical outline form. Each level is
indented slightly from the previous level (for example, Level 1 is at left
margin, Level 2 has 1/4 inch indent, Level 3 has 1/2 inch, Level 4 has 3/4
inch, etc.). Each paragraph starts with a bulllet, with a different bullet
character for each level.)

I'd like to copy to Excel 2003 and look approximately the same. When I do
this through simple copy-and-paste, Excel puts each paragraph into a cell.
Indentation and bullet characters are retained. However, there is no word
wrap - each paragraph is on a single line, extending possibly far to the
right.

When I then add word-wrap (Format / Cells / Alignment / Word Wrap), Excel
retains the bullet characters, but loses the indentation. Everything is
left-justified.

I've confirmed that word wrap is not inconsistent with cell indent; I can
take a word wrapped cell and indent it. So I could achieve the desired
format if I manually add the indents for each cell, but that's obviously
cumbersome.

Is there any easier way? (I.e. Copy text from Word to Excel, retain word
wrap, retain indent.)

Thanks.
 
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
How can I use word wrap in a merged cell in excel 2000? PartnersHC Excel Discussion (Misc queries) 4 October 18th 09 10:02 PM
word wrap in excel jeremy Excel Discussion (Misc queries) 2 April 26th 06 05:14 PM
How do I merge from Excel into Word doc and retain formatting? John Excel Discussion (Misc queries) 4 December 12th 05 02:07 PM
Excel 2003 Word Wrap Problem within cell Dan S. Excel Discussion (Misc queries) 1 October 17th 05 03:54 PM
How to embed Word document into Excel and retain sizing, formatti. Kent Excel Discussion (Misc queries) 0 February 2nd 05 07:37 PM


All times are GMT +1. The time now is 06:30 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"