Controlling output format when exporting to text

[RonaldHollander]

Hello forum go'ers!

I am new to excel. After organizing my data I now need to export to a simple txt file. But I need to control to final format better then the simple "save as" allows. What I need is a simple list of in a single column, separated by a carriage return. I am working with a "small" list of addresses, and by small I mean 27,188.

Every format I try ends up with quotation marks and a strange box like symbol. What I have is a full name and 2 line address per field in .xlsx format. I also have the data separated into fields by line.

Is there any way to better control the output when exporting to a .txt file?

Thanks for taking the time to read and respond.

[xenixman]

To remove the quote marks, the simplest way is to

Select: Save As,
Select: Other Formats,
Select: Formatted Text (Space Delimited)
it will be saved with a .PRN extension, just change the extension to .TXT

See how that works.

[RonaldHollander]

It did! I need to tweak my xlsx format slightly, but I think it will work perfectly! It seems to have a 40 character per field limit, but I can work within that.

Thanks!