New Line Character

  • Thread starter Thread starter JohnBon
  • Start date Start date
J

JohnBon

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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import File Line by Line 1
Carriage return character 8
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
I can't figure this out - please help 1
How can I make Excel read a value from a textfile and assign it to a variable in my VBA code?? 2
Need help with a vb function 1
Strip records from large textfile with VBA 4
Importing one row takes the place of two 1

Back
Top