| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to display file name
Hi Expert,
Is there a function to display the file name in cell please? Thanks Elton |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to display file name
This formula only works after the file has been saved at least once...in any
cell: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,(FIND("]",CELL("filename",A1))+1)-FIND("[",CELL("filename",A1))-2) -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "Elton Law" wrote: Hi Expert, Is there a function to display the file name in cell please? Thanks Elton |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to display file name
Hi Rocket Scentist,
Terrific, it works ... Thanks indeed. Elton "JBeaucaire" wrote: This formula only works after the file has been saved at least once...in any cell: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,(FIND("]",CELL("filename",A1))+1)-FIND("[",CELL("filename",A1))-2) -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "Elton Law" wrote: Hi Expert, Is there a function to display the file name in cell please? Thanks Elton |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Name Display | Excel Discussion (Misc queries) | |||
| How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
| Function To Dynamically Display File Size | Excel Worksheet Functions | |||
| Different display for same file | Excel Discussion (Misc queries) | |||
| can I display the file name of the imported text file in another c | Excel Discussion (Misc queries) | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
