Excel import Q

[Juliemac]

I have text files I need to import into Excel 2010.
The cols are delimited by CR/LF.

The excel import wizard does not allow it. It has "Other" but I can't see how to enter a code.
How can this be done?

[Jacc]

Would this help?
http://www.excelforum.com/excel-prog...a-comment.html

[Juliemac]

If I wrote code to pull it in. I have 70 separate text files (flat files) that need to load one at at time.
On step 2 of the wizard, it shows "Other", if I hit Alt/Enter excel beeps...
Hitting "Enter' takes me to the next step. entering Chr$(10) or 13 is not allowed.

None of the other selections will work

[Jacc]

Can't you type the code in a cell and then copy/paste?

[Juliemac]

The text file contains data like this
<quote>
104E3662G2
7x2 Part 2
110
110
220
500000
1
28
49
76
0
0
500
1
100
Super user
2013/04/03 12:45:58
</quote>
Each line contains a CR/LF or 0D0A. I need to be able to pull this into excel
But the wizard does not seem to have a way to use CR/LF as a delimiter

[Jacc]

Yes I understand the problem. What I meant was that you could paste the invisible carriage return character into the box in the wizard.
Or you could just google "text to columns carriage return", quite a few results.

http://www.excelforum.com/excel-form...ge-return.html
http://www.excelbanter.com/showthread.php?t=53015

The keyword here seems to be "numeric keypad". I don't know what to do if you're on a laptop (other than borrowing someones keyboard and plug-in for a minute ).

[Alf]

can you upload a sample of the text file?

Alf

[Juliemac]

That was a cut & paste. At each line break is a cr/lf.

As far as I can see Excel has no way of defining them in the wizard....