bamaisgreat
Well-known Member
- Joined
- Jan 23, 2012
- Messages
- 821
- Office Version
- 365
- Platform
- Windows
Thanks for looking at my post as always.
I have the following formula in a cell that displays the file name.
=LEFT(CELL("filename"),FIND("]",CELL("filename"))-1)
THe problem I have with this is I need it to show only the filename. It shows the file path also. Is there away to edit the formula so it only shows the name?
Thanks
I have the following formula in a cell that displays the file name.
=LEFT(CELL("filename"),FIND("]",CELL("filename"))-1)
THe problem I have with this is I need it to show only the filename. It shows the file path also. Is there away to edit the formula so it only shows the name?
Thanks