Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Line Character
Hi
I'm producing delimited text files that are to be imported into Excel. Is there something that I could write to force Excel to make a carriage return? Like writing \n or similar in the textfile. /Johnbon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Line Character
You mean so that excel will read the file and put separate lines on separate
rows. It should do that automatically. It will see the end of line as being marked by two characters a Carriage Return and LineFeed combination. This is the windows standard. I don't recall what the Unix standard is - it is either the Carriage return alone or the linefeed alone (I believe LF). In any event, I believe Excel will also treat this as a newline indicator. -- Regards, Tom Ogilvy "JohnBon" wrote in message om... Hi I'm producing delimited text files that are to be imported into Excel. Is there something that I could write to force Excel to make a carriage return? Like writing \n or similar in the textfile. /Johnbon |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Line Character
Hej
Yes, but I dont' want the text file to have visible Carriage Returns. It would be better if I just could write some character like \n or vbCRLF. Is it possible? /Johnbon "Tom Ogilvy" wrote in message ... You mean so that excel will read the file and put separate lines on separate rows. It should do that automatically. It will see the end of line as being marked by two characters a Carriage Return and LineFeed combination. This is the windows standard. I don't recall what the Unix standard is - it is either the Carriage return alone or the linefeed alone (I believe LF). In any event, I believe Excel will also treat this as a newline indicator. -- Regards, Tom Ogilvy "JohnBon" wrote in message om... Hi I'm producing delimited text files that are to be imported into Excel. Is there something that I could write to force Excel to make a carriage return? Like writing \n or similar in the textfile. /Johnbon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Character for second line in a cell | Excel Discussion (Misc queries) | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
replace new line character | Excel Discussion (Misc queries) | |||
Searching for a new line character. | Excel Discussion (Misc queries) | |||
special character - line feed | Excel Programming |