Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Sarah R Sarah R is offline
external usenet poster
 
Posts: 21
Default How to force word wrap in Excel cell for Word merge?

In Excel, some of the field entries need to be multiple lines, so the data
were entered using [Alt+Enter]. However, after a merge [Alt+Enter] converts
into Word as a paragraph marker -- not the equivalent of Word's
[Shift+Enter].

In the Word merge document, there are typed labels at the beginning of a
line, followed by a [Tab] and then the merged data from Excel. For those
fields with [Alt+Enter] in Excel, the multiple lines begin at 0" (left
margin) rather than at the tab. (The style is set to tab and hanging indent
at 2.5", so the real issue is that the codes are interpreted in Word as
paragraph markers.)

Is there a special code or other trick to preserve line breaks from Excel
into Word?
--
-- Sarah
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I turn off word wrap in a cell in a table? kavman Tables 4 May 8th 23 08:48 PM
Merge in Word doesn't pull in all data from the excel file cell Venus930 Microsoft Word Help 0 April 8th 08 07:36 PM
Problems w/Justified Word Wrap w/in table cell JeffP-> Page Layout 0 March 11th 08 04:45 PM
How do I force text to wrap to the next row in a Word table? AdrienneC Tables 1 August 31st 07 07:08 PM
How to wrap text from cell to cell in a table. Jon Coulson Tables 2 August 8th 05 09:12 PM


All times are GMT +1. The time now is 06:46 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"