Add Line break to string for Excel (using c#)
 

I'm adding som data to a string that will be imported to Excel. I need
to add line breaks in the text sp that they are visible in Excel but
what string should I insert?

/Ladyhawke

Add Line break to string for Excel (using c#)
 

Chr(10)

NickHK

"ladyhawke" wrote in message
oups.com...
I'm adding som data to a string that will be imported to Excel. I need
to add line breaks in the text sp that they are visible in Excel but
what string should I insert?

/Ladyhawke

Add Line break to string for Excel (using c#)
 

NickHK wrote:
Chr(10)


or chr(13)

Add Line break to string for Excel (using c#)
 

I assumed the OP wanted to put a line break in text all contained in a cell.
If it somewhere else it would depend, possibly the C# equivalent of
vbNewLine or Chr(13).

NickHK

"Morris"
egroups.com...

NickHK wrote:
Chr(10)


or chr(13)

Add Line break to string for Excel (using c#)
 

vbCrLf combines Chr(10) and Chr(13) for carriage return and line feed.

"ladyhawke" wrote:

I'm adding som data to a string that will be imported to Excel. I need
to add line breaks in the text sp that they are visible in Excel but
what string should I insert?

/Ladyhawke

Add Line break to string for Excel (using c#)
 

Would Char(13) equal soft line break? That is whats needed here... If I
insert Char(10) it will change line in the comma seperated file
(thereby initializing a new dataline (not wanted))