Get File Name From File Path in Excel | Vivekananda Sinha | Video 232
Get File Name From File Path in Excel
Imagine, you have a list of very long, complicated file names and paths and your manager wants a list of file names extracted from these paths. In Excel, there is no direct method or function to get this but we can use an amazing formula to Get File Name From File Path in Excel. In this tutorial, I will show one amazing Nested Formula to get this done. It will work across all versions of Excel. Be it Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, or Excel 365.
00:00 Start
01:16 Understanding the Requirement
01:37 Building the Logic
02:22 Using SUBSTITUTE Function
02:39 Using REPT Function
03:26 Using RIGHT Function
04:07 Using TRIM Function
04:40 Wrapup
⯆ Download the file here: https://futureinhands.com/youtube/ass...
In this Excel tutorial we cover a few important topics rather quickly:
Get File Name From Full Path in Excel
Get File Name From File Path in Excel
Extract File Name from Full Path in Excel
Excel SUBSTITUTE Function
Excel TRIM Function
Excel REPT Function
Excel RIGHT Function
Excel Nested Formulas
File Management in Excel
★ MUSIC IN THIS VIDEO
Music by / ikson
★ Let’s connect on social:
Our Telegram Group: fih.one/telegram
My LinkedIn Profile: fih.one/vs-linkedin
My Facebook Profile: fih.one/vs-facebook
Our LinkedIn Page: fih.one/linkedin
Our Facebook Page: fih.one/facebook
#FutureInHands #VivekanandaSinha #MicrosoftExcel #MicrosoftOffice #bestexceltrick #exceltutorial #exceltraining #exceladvanced #excel #excelfunctions #exceltips #best #dataanalytics #excel #filename #nestedformula #formula #excelformula