In order to accomplish this, you will need to do two things, the first is in your mapper, where you want a new line, you’ll use a \n in the string. You’ll have to do this with an expression-enabled field (you can’t type it out plain text without doing a later replacement of \\n with \n. Below is a screenshot from an example mapper (pipeline is attached at the bottom of this post)
The Second thing you will have to do is in excel, for any cell(s) that have line breaks, you’ll have to enable wrapping on said cells. This may differ based on your specific excel version, but on the mac version it’s under “Format Cells” → “Alignment” → “Text control:” → “Wrap text” (see screenshot below)
With all of these steps, you’ll see the excel now displays the new lines appropriately:
Excel New Line_2023_04_05.slp (5.2 KB)
