Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Line break to string for Excel (using c#)
NickHK wrote: Chr(10) or chr(13) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i add a line break into a formula in excel 2000? | Excel Discussion (Misc queries) | |||
How to get a line to locate at the page break in excel | Excel Discussion (Misc queries) | |||
Replacing a hard line break in Excel | Excel Discussion (Misc queries) | |||
Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
Why can't I get 'alt enter' to create a line break in Excel? | Excel Discussion (Misc queries) |