But if you convert this text file to Excel you have access to the file
it (e.g. the conversion in Excel will also alter the file). So just
change it first?? (of course create a copy of the original source file)
Though you can do the same principle in Excel using VBA (opening the
file, replacing the double spaces, starting the import)
Frank

Frank i cant edit the text file , it is somthing generated by an
automated process and we cant do that .


---
Message posted from http://www.ExcelForum.com/