Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
newline | New Users to Excel | |||
Insert newline in cell through formula (excel 2003) | Excel Worksheet Functions | |||
Returning newline from a function to a cell | Excel Programming | |||
newline in a msgbox | Excel Programming | |||
DDE an Alt-Enter (Newline) character | Excel Programming |