Extract text data and file name from .vcf into cell

[ajt56]

Hi All,

I am trying to extract the text data from a .vcf file and place it into one cell along with its filename. I don't need to separate the data into seperate columns, purely just take it from the .vcf and place it into the excel cell.

I have attached a screenshot of what the end result should look like:

As you can see the data from the .vcf is in once cell on the left and the name of the .vcf file is on the right.

I would want to select multiple files and have a VBA code extra each files data and file name and place them into the cells, one after the other, all in the same two columns (A and B). The line spacing of the data must also remain the same.

Any ideas of what I could do?

Thanks in advance!