I need to import 1500 files into one excel worksheet. The text files are in folder that is name of the language (e.g en for English). Now what i intent to do is to make appear my language name in one column under heading language name(that's folder name, will be repeated 1500 times) and language text in next column. My text files has either one sentence or either a paragraph. I don't want it to be in different columns. I tried a piece of code from this forum it helped a lotbut text appears scattered.
P.S I am totally a newbie at VBA. Any help will be appreciated plz. For text idea I am also attaching the text files. These Text files are from a Data set that has different languages in these text files. And for each language i have to do this. Image shows how the text appears