![]() |
Add a Newline in a Cell
Hi All,
I'm writing output to an Excel file. I have to write all of the differences into a single cell. Now I've got an output that looks like this (in a single cell): The number of text objects differ on page 1: 12; 10 | The number of text objects differ on page 1: 17; 15 | The number of text objects differ on page 1: 17; 15 | The number of text objects differ on page 1: 16; 14 | The number of text objects differ on page 1: 17; 15 | The number of text objects differ on page 1: 18; 16 | As you can see, it's humanly readable. I want to make it look like following: The number of text objects differ on page 1: 12, 10 The number of text objects differ on page 1: 17, 15 The number of text objects differ on page 1: 17, 15 The number of text objects differ on page 1: 16, 14 The number of text objects differ on page 1: 17, 15 The number of text objects differ on page 1: 18, 16 I don't know how to make it look like this. Because, if I add a a newline ("\r\n") after each difference, this will be split into 6 separate lines - They won't be in the same cell anymore. Any advice? Thanks! -Emily |
All times are GMT +1. The time now is 12:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com