How to export/program/macro from excel to .txt file?

[Absalon]

Good evening from Norway,

I have a delicate issue that I need some help with. I have a spreadsheet with loads of data rows and columns that need to be exported to a .txt file for upload to a database. Hence, the spesific format is what I am struggeling with.

The format needs to be like this:

“Customerno” “Name” “Address” zip code” “zip code name” “Phone” ”MecCode” ”SalesCode”
"134871" "MOLO KYST RESTAURANT" "VALLEVEIEN 1000" "3960" "STATHELLE" "99627181" "" "233"
"129978" "BURGY SIRKUS SHOPPING" "FALKENBORGVEIEN 5" "7044" "TRONDHEIM" "97969552" "" "534"


I have no idea of how to do this, but maybe one of you guys can help?

Attached the spreadsheet with the data. If this is possible with a formula, it would be great to have it in column Q or R