| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding part of fole path
OK, here is what i have. I have a muisc list that I get from file
names from a playlist. i get the artist name and the song name from the path of the file using playlist files (txt format), Now i want the album name too. File name goes something like this: d:\Music\Beatles\Rubber Soul\Beatles - Drive My Car.mp3 Album name is Rubber Soul and is always the last "path" entry before the file name. Is there a formula that I can use to get "Rubber Soul"?? TIA Sheila |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use a cell value as part of a link's path name? | Excel Discussion (Misc queries) | |||
| I need help with an "If" Statement | Excel Worksheet Functions | |||
| Part Number/Qty Consolidations | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Threaded Mode
