Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() NickHK wrote: Chr(10) or chr(13) |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |