From Excel to notepad (.txt)

Undertegnede

New Member
Joined
Oct 15, 2013
Messages
12
Hi,

I wanted to see if anyone knew a way to convert a dataset from Excel to notepad (.txt). I need data in .txt format in order to import it to our ERP-system (UBW.

The input would look like this (9 columns, usually a couple thousand rows):

101000SKOST300,51000B3K0101.10.201830.09.2019
302000SKOST450,11000B3K0201.10.201830.09.2019

<tbody>
</tbody>


Output (in .txt) should look like this (each column from Excel is split by X-number of spaces):

10 1000 SKOST 300C5 1000 B3 K01 2018100120190930
30 2000 SKOST 450C1 1000 B3 K02 2018100120190930



Best regards
 
Last edited:

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,109,157
Messages
5,527,131
Members
409,749
Latest member
esmarques

This Week's Hot Topics

Top