Simple Excel sheet data to .Dat format conversion

[zaska]

Hello,

I have data in Two Columns and i want to convert that data into .dat Text file. Can anyone help me with a VBA code to covert the data in excel sheet to a .dat text file. I have attached the sample files for reference.

Thank you

[LJMetzger]

You can try:
File > save as either:
a. Formatted text (space delimited) creates a nicely aligned file with .prn extension that looks very much like your sample output file.
b. Unicode text (.txt)
c. Text (tab delimited (.txt)
d. Text MS-DOS text (.txt)

Choices b thru d don't align all that well with your data.

If none of the choices work, a Macro could be written to output to a text
file in almost any output format you want.

Lewis

[martindwilson]

i dont think there is a particular format to a .dat file it depends on what the system you are uploading to requires so try as
LJMetzger suggests or ask whoever wants it what format it should be in