Import txt file to excel 2010

[Itaybill]

Hi All

i have a text file that i would like to import to excel.
the text file contains several columns, and seperated by commas.
There is a row of free text that causes me a lot of trouble: in most of the rows there is an extra space between the words, that creates new row in the excel (after import) in the first column! (the free text column is one of the last columns in the text file).

what can be done to prevent this? correcting the text file is not an option, because there are a lot of rows there...


Thanks!


Itay

 

[moonfish]

Do you think you could show us an example of your text file, an example of what it looks like when you import it and an example of what you want it to look like?

 

[Itaybill]

example of the text file (the gaps in the second row appear in the text file as well)

Job ID,Init ID,T ID,Date,Host PC Name,Machine Name,Error Message,Stop Reason, S Number
122009,122009 ,122009,08/30/08,VWAGWOCE,O500,Stopped
2440285,244028 ,244028,09/02/08,VWAGWOCE,O500,This tray was prepared for building in High Q mode using material While the system is loaded with: X material Y material Use Wizard to change desired material .

example of the excel file (after import - i added only the second row):

Job ID Init ID Tray ID Date Host PC Name Machine Name Error Message
2440285 244028 244028 09/02/08 VWAGWOCE O500 This tray was prepared for building in
High Q mode using material
While the system is loaded with:
X material
Y material

Use Wizard to change desired material


i expecte to see the "Error message" row without any spaces and in one sentence.


Itay

 

[Sektor]

= substitute(a7,char(10),"")

 

[moonfish]

It's not giving me any trouble at all. I copied your sample and saved it as a *.txt file, then imported it with a comma as a delimiter. The error message went into a single cell.

It could be that someone opened your text file in notepad with word wrap enabled and then saved it, creating unwanted line breaks in your source data. To be honest though, I'm clueless as to what the cause is. Maybe someone else has a good suggestion.