Display a full file path name in a specific cell

Originally Posted by royUK

Try

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

Thanks but maybe I need to be a bit more explicit. It is the path/location name (C:\david\documents\...etc) I am after which I want Excel to "discover" and then display into a given cell

Hopefully that means something to somebody?

Best regards,

David