Hi all,
I have 48 text files that need converting to Excel.
The obvious answer found in most forums uses the following code:
The problem is this converts the text from the files in a single column of each excel workbook as opposed to distributed into columns.![]()
Please Login or Register to view this content.
Excel's Text Wizard sorts this problem for manual conversions, so using the macro recorder, I've identified a code for manual, correct conversion as :
Can someone please suggest a code which combines the two and allows me to convert all 48 .txt files into correctly formatted Excel files, please?![]()
Please Login or Register to view this content.
Thanks!!
Bookmarks