How to remove filename from Path?

Hello. Is there a way to remove the excel file name from Path?

Example… if I have an excel file with multiple row referencing different Paths

(ie. C:\doc1\doc2\file1.xlsx), how do extract the folder/directory portion only (C:\doc1\doc2)?

I’ve try searching and trying for the past 2 hours… no luck :frowning:

Thanks in advance.