Hi just asking for help I just wanted to know what do I Need to do to get the file path with the Subfolder
Here's the scenario:
I have 4 Folders Under my main folder:
Main_folder
-----Folder_1
-----Folder_2
-----Folder_3
-----Folder_4- 1 Excel files (Here's my Excel file to input the file path)
And I want to get the file path of other folders 1 to 3 and put to my excel file under Folder_4
Here's my formula But in that formula I only got the Folder_4 file path I wish anybody here can help me.
=LEFT(CELL("filename"),SEARCH("\[",CELL("filename")))
sample file i upload for the reference thank you so much in advance.
Expected Result.PNG
Bookmarks