Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to force word wrap in Excel cell for Word merge?
I believe that the issue is that Excel does not have the ability to insert a
hard line break. I does not have the equivalent of Shift + Enter in Word and as you have discovered Excel's Alt+Enter is the same as Enter in Word. The correct thing to have done in Excel would have been to format the cells so that the text in them would wrap. It would then have been treated as just one long string of data and would wrap in Word at the end of the line. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Sarah R" wrote in message news 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn off word wrap in a cell in a table? | Tables | |||
Merge in Word doesn't pull in all data from the excel file cell | Microsoft Word Help | |||
Problems w/Justified Word Wrap w/in table cell | Page Layout | |||
How do I force text to wrap to the next row in a Word table? | Tables | |||
How to wrap text from cell to cell in a table. | Tables |