-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Show Filename in cell
- Thread starter Fram
- Start date
Dave Patton
Well-known Member
- Joined
- Feb 15, 2002
- Messages
- 6,480
- Office Version
- 365
- 2010
- Platform
- Windows
Put the following in the cell where you want to show the filename.
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)
Notes:
1. The file must be saved with a name.
2. The reference to a cell A1 is required.
This message was edited by Dave Patton on 2002-05-08 13:00
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)
Notes:
1. The file must be saved with a name.
2. The reference to a cell A1 is required.
This message was edited by Dave Patton on 2002-05-08 13:00
Upvote
0
Similar threads
- Question
