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

 

[AlphaFrog]

Try this...

=TRIM(MID(SUBSTITUTE(CELL("filename",A1),"",REPT(" ", 100)),(LEN(CELL("filename",A1))-LEN(SUBSTITUTE(CELL("filename",A1),"",""))-1)*100,100))

 

[djl0525]

Thanks for the quick reply.

I got #VALUE!

Your thoughts?

DJ

 

[djl0525]

Can somebody help me with this?

DJ

 

[AliGW]

What exactly do you get as a result of this?


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

 

[djl0525]

I get the path to the file

C:\Users\...\...\...\folder name I want\

Is there a way to capture the characters between the last two backslashes?

DJ

 

[AliGW]

Is that the exact number of backslashes?

 

[djl0525]

No, and it can change if/when the file is moved or copied to another computer.

Can we count the backslashes from the right?

 

[AliGW]

I was going to try and help, but I am getting the #VALUE! error with all of the formulae mentioned so far. Sorry!

 

[djl0525]

Did you save your workbook? You'll get #VALUE! if the file is not saved.