Forum Discussion
=Folder()
Heres a quick question, I know that in Excel, Using Named Formulas we can do =FILES({cellRef}&"*") and in the {cellRef} have an address like "C:\Docs\" then a formula =Index({NamedFormaula,ROW(A1))...
Hi
You can try using PowerQuery
This might be helpful for you
⏱Extract File Name, Path, Size,Without Macro in 10 seconds
https://youtu.be/kHylnj7sh-c
Regards, Faraz Shaikh
You can try using PowerQuery
This might be helpful for you
⏱Extract File Name, Path, Size,Without Macro in 10 seconds
https://youtu.be/kHylnj7sh-c
Regards, Faraz Shaikh
ExcelExciting genius, I cant believe, even though I have been fiddling with this area for lots of other things I hadn't thought of that. that's amazing!
Stephen_Edwards Glad to hear your query is resolved 😃👍
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com