LinkBack URL
About LinkBacks
Hello,
I presented on the attached file ‘ExtractFileNameFromFullPath.xlsx’ the way I use extracting the file name from its full path.
I wonder if there is a better way to do it.
Thank you.
Hello,
I presented on the attached file ‘ExtractFileNameFromFullPath.xlsx’ the way I use extracting the file name from its full path.
I wonder if there is a better way to do it.
Thank you.
Administrative Note:
Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
Try this:
=TRIM(RIGHT(SUBSTITUTE(D5,"\",REPT(" ",99)),98))
Last edited by AliGW; 07-22-2022 at 01:56 AM. Reason: Added example workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you for the formula.
For instance, I use Excel 2007 on Windows 7.
Last edited by AliGW; 07-22-2022 at 05:57 AM. Reason: Please DON'T quote unnecessarily!
That's fine - I was just checking that 2007 was correct in your profile.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks