Get the file path without the file name

[jwalkerack]

Hello ,

i have a long list of file directories on a spreadsheet.

Intially i wanted to seperate the file name. i was able to find a post online which allowed me to do this

get filename from filepath and filename

But now i would like to just have the file path without the file name

So if my full directory was

S:\AppsData\Excel\Jack\TEST\Football_players.xls

i would like the end result to be

S:\AppsData\Excel\Jack\TEST\


Is there an easy way of doing this ...


Thanks a lot Jack

 

[jwalkerack]

Thanks Guys , that was great , help , i had already for the file name from the at link i had on the first message of the post.

i was then used the subsitute formala as you guys , stated ,

Thanks a lot