Hi Everyone
Could someone please tell me a formula to insert into a cell that will display the same discription as the file name.
Thanks
Hi Everyone
Could someone please tell me a formula to insert into a cell that will display the same discription as the file name.
Thanks
Try
=CELL("filename", A1)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
hi Onesock. maybe try:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi Mike
Unfortunatly the formula gives the whole path name - I just needed the file name.
Thanks for trying.
Regards
Hi
Works great !! . Is there some way that it can work without showing the file extension in the file name . ie can it leave out the .xls
Hoping
how about:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND(".xl",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)
Or
On Saved Workbook
Formula:Please Login or Register to view this content.
For 2003 use the below formula to get the file name and the notification message for unsaved workbook
Formula:Please Login or Register to view this content.
For 2007 use the below formula to get the file name and the notification message for unsaved workbook
Formula:Please Login or Register to view this content.
Hope that helps!
Last edited by :) Sixthsense :); 10-23-2012 at 12:14 PM. Reason: Correction in formula
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Internet connection problem same post getting posted twice, so replacing the duplicate post with this message.
Regret for the inconvenience.
Last edited by :) Sixthsense :); 10-23-2012 at 12:09 PM.
Yip Thanks
That works exactly how I need it too !!!1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks