Bulk Import Text Files, One per Row

[raywood]

I have a folder containing a number of text files. I think I could manually copy their contents and paste them into single Excel cells, one at a time. But is there a way to automate that?

I would swear I did something like this once before. But it was a long time ago, and I am not finding any notes on it. My search leads to a SuperUser answer that may have potential - but I don't understand it. As it is, it seems to be oriented toward processing one text file at a time.

 

[raywood]

I have a folder containing a number of text files. I think I could manually copy their contents and paste them into single Excel cells, one at a time, so that the contents of each text file would fill one cell. But is there a way to automate that?

I would swear I did something like this once before. But it was a long time ago, and I am not finding any notes on it. My search leads to a SuperUser answer that may have potential - but I don't understand it. As it is, it seems to be oriented toward processing one text file at a time.