Get Folder Name

[djl0525]

I know how to get the file path...

=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

But is there a way to get just the FOLDER name (not the entire path) of the current file?

DJ

 

[djl0525]

Re: Get Folder Name only from pathe

You got it! It worked! Thank you so much!!!

DJ

P.S. It was nice chatting with your alter ego as well.

 

[djl0525]

Y'know... lots of people are seeking ways to get the current folder in a cell. You should blast this formula all over the internet because I looked for it (a non-VB solution) and it was nowhere to be found!

DJ

 

[AliGW]

Hopefully this thread will now come up in Google searches.

 

[deciog]

djl0525


=MID(CELL("filename",A1);FIND("]",CELL("filename",A1))+1,31)


Would that be what you want?


Decio

 

[AliGW]

djl0525


=MID(CELL("filename",A1);FIND("]",CELL("filename",A1))+1,31)


Would that be what you want?


Decio

That returns the sheet name. The OP wanted the folder name from the file path.

 

[Dave Patton]

=REPLACE(CELL("filename"),FIND("[",CELL("filename")),LEN(CELL("filename")),"")

 

[AliGW]

That returns the whole file path including the final folder: the OP asked for a formula to return JUST the final folder.

 

[Aladin Akyurek]

See post #10 in your other thread http://www.mrexcel.com/forum/excel-questions/983210-find-text-between-backslashes-string.html

 

[navic]

Display Folder Name where is opened Workbook placed

You should blast this formula all over the internet because I looked for it (a non-VB solution) and it was nowhere to be found!

I can not you understand fully well.
If you want to know how I created this long formula and from which parts of this formula is made, you can see a complete tutorial with screenshots. (I created tutorial for you)

How to return the name of the subfolder only, where it is located opened Excel Workbook.

My apologies for the bad english.
Greetings from Croatian and all the best in this new year 2017.