txt to excel to txt

[Drreamsurferr]

Hi

I have a txt file which I download into excel (reformatted using the default settings in excel - deliminated). I change one column of data & the data is represented in the same format.

How do I save the excel to a txt file applying the same formats??

help appreciated

[shg]

Text files are just that -- they don't store formats.

[Drreamsurferr]

OK so how do i get the downloaded text file to look like the text file?? can i give you a three line example?

[shg]

An example would be good.

[Drreamsurferr]

Hi

Thanks, pls see below, the decrebate file is the txt file.

Once this is downloaded into excel it looks like the excelexample.

I need the excelexample to be saved in txt format for upload (looking like the text file).

Thanks :-)

[shg]

When you open the text file, you have to be deliberate in specifying that the long numeric strings are imported as text, otherwise you lose the significant digits beyond 15, e.g., 2009123120091231 becomes 2009123120091230 (as your example shows).

The source file is fixed-width, space delimited. When you save it from Excel as text, you get tab-delimited output. You can re-open the output in Excel in Excel to get the same result, again with due care to import long numeric strings as text.

To my knowledge, you'd have to write code to output in space-delimited fashion.

[Drreamsurferr]

Hey,

Thanks v much for your reply!!