Hi
I have to export 6 columns of data to notepad, to feed into another system.
All ok, but I have to ensure that each entry in the column is made up of 16 characters, using spaces where there are no words.
i.e.
In Excel
qwerty qwew qqqq
hi hello heellllllo
In Notepad
qwerty qwew qqqq
hi hello heelllllo
This way the batch program can read the columns in the txt file.
Any ideas?
I have to export 6 columns of data to notepad, to feed into another system.
All ok, but I have to ensure that each entry in the column is made up of 16 characters, using spaces where there are no words.
i.e.
In Excel
qwerty qwew qqqq
hi hello heellllllo
In Notepad
qwerty qwew qqqq
hi hello heelllllo
This way the batch program can read the columns in the txt file.
Any ideas?