Andrew Fergus
MrExcel MVP
- Joined
- Sep 9, 2004
- Messages
- 5,462
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Hi
I'm helping someone automate a process and we are performing a mail merge in Word based on an Excel document. There is a text field into which the user enters a description. Often multiple carriage returns are entered in the particular cell in the Excel document using Alt+Enter. This provides some basic formatting to space out the text a little.
What I am seeing in the mail merged document is that a single carriage return (entered using Alt+Enter in Excel) comes through into the mail merge document ok. However, a double carriage return (ie 2 consecutive carriage returns) only ever comes through as one carriage return in the Word document.
Does anyone have any thoughts on why this would be doing this? Or how we can stop the Word document from ignoring the double carriage returns?
Thanks
Andrew
I'm helping someone automate a process and we are performing a mail merge in Word based on an Excel document. There is a text field into which the user enters a description. Often multiple carriage returns are entered in the particular cell in the Excel document using Alt+Enter. This provides some basic formatting to space out the text a little.
What I am seeing in the mail merged document is that a single carriage return (entered using Alt+Enter in Excel) comes through into the mail merge document ok. However, a double carriage return (ie 2 consecutive carriage returns) only ever comes through as one carriage return in the Word document.
Does anyone have any thoughts on why this would be doing this? Or how we can stop the Word document from ignoring the double carriage returns?
Thanks
Andrew