| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separating Location and Filename in a cell
I have a long list of Files which include the complete path. I need tro
separate the filename ("JohnDoe.xls") from the first part of the cell ("C:\Files\Clients\"). In some cells the path includes numerous subfolders so the formula needs to take that into consideration. I have seen workable formulas in this site but cannot, for the life of me, find them now. Any and all help is greatly appreciated. -- Best wishes, Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make an external link to a filename defined by a cell value | Links and Linking in Excel | |||
| Worksheet tab in cell | Excel Discussion (Misc queries) | |||
| Put Filename Variable in Macro | Excel Discussion (Misc queries) | |||
| cell filename | Excel Discussion (Misc queries) | |||
| Hyperlink more than one cell at a time? | New Users to Excel | |||
Threaded Mode
