Converting text file in to excel file

[Guest]

When i am converting .txt or .lis in to excel format - during the period if any particular column description wrap, i want to bring in to single row.

anyone can help or suggest how to do that?

thank
ashok

 

[Dave Peterson]

I'm not sure what a .lis file is, but if it's plain text like most .txt files,
then this is tougher than you would think.

Excel sees every line in the text file as something that should be parsed to a
new row.

You could either come up with some rules that would specify how one line would
be considered an overflow of the previous. Then import the text file and
"recombine" cells based on those rules.

Or you could actually do the work while you're reading the file into excel.
You'd still have to know your rules, though.

There are some instructions on how to do read files like this at:

File Access with Visual Basic® for Applications
http://support.microsoft.com/support/excel/content/fileio/fileio.asp