I'm trying to convert an Excel file with simple data ordered in columns into a txt file.
The txt file mixes up the data and the columns are disorganised. Is there any way to keep the simple organisation of the data ?Many thanks
You may try to save as space-delimited (.prn) file
but it has some limits
thank you for your suggestion, it worked. I'm going to try to work around the character limitation.
Try to copy your data, and paste it in a text file as follows:
Press F12, and save your workbook as Text (Tab delimited) (*.txt) type.
In both cases, your data is supposed to remain organized and separated by tab character, unless there is a problem!
Thanks for your suggestions. I unfortunately tried both and the data gets mixed up everytime :