Hi all!
been searching for a while and couldn't find anything that worked. So here it goes

I am looking for a way to auto fill a column in excel sheets with file names from a directory

for example
lets say i have a hundred pdf files in in C:\documents\
and all these pdfs are named sequentially> For eg 1-3.10.14-abc.pdf, 2-3.11.14-def.pdf so on and so forth

How do i get excel to recognize the pattern and auto populate a cloumn with the file names in the document folder?
Is there a way i can only extract a portion of the file name? For eg, can i have the "abc.pdf" portion of the file name in one column and "3.10.14" portion of the file name in a different column ?