i have like 100 Text files id like to convert in to excel files
Text Flile "List1":
Import of the Text File in Excel BUT i have to change the formation to text so that my numbers stay correct:
In the end it schould look like the text file just in excel (the green column1,2,... are not nessesary)
Last step would be saving the excel with the same name as the txt (List1.exe)
As i said i have like 100 txt files to convert per day and it would be amazing if i could just transform them all at one. The txt files are aktually all the same the only difference ist that in column 1 the nummer varries from 4 characters to 9.