Import Multiple Text Files Into Single Worksheet

Hi All,

I have 150 .txt files that I'd like to import into a single worksheet.

The .txt file is an article.

Ideally, I'd love to have each .txt file imported like this:

Title of article in Column A >>> Rest of article in Column B

Is there a quick way to import these files (and hopefully separate the title/article)?

Thanks so much!

-Coz