If I have a excel file with 2 column one with numbers 1,2,3,............ in column A and series of letters in column B, a,b,c,............. Is there a way I can export it to a txt files for each rows ,
first row as to display as and export as file1.txt
<a blank gap is important>
Second row as to display as and export as as file2.txt
and so on till the last row
i found a micro which does the job but it export only the first row
i got this code from here
Will be very grateful if you can solve this !
Many thanks !