How to Get Filename from Path in Excel: 7 Simple Methods

Method 1 – Use Find and Replace Feature to Get Filename from Path

Steps:

• Select cells (B5:B11) from the worksheet with paths.
• Selecting cells press Ctrl+H from the keyboard.

• A new window will appear. From the appeared window, type “*\” in the “Find what” box and click “Replace All”.

• Get the filename from the path within the same column.

Method 2 – Combine LEN, SUBSTITUTE, FIND, and MID Functions to Get Filename from PathSteps:

• Select a cell (C5) and write the following formula down-

Method 3 – Combine REPT, SUBSTITUTE, RIGHT, and TRIM Functions to Get Filename from Path

Steps:

• Choose a cell (C5) and write the following formula down-

• Hit Enter and pull the “fill handle” to get the result in all cells.

Method 4 – Combine CHOOSECOLS and TEXTSPLIT Functions to Get Filename from Path

Steps:

• Choose a cell (C5) and write the following formula down-

• Hit Enter and pull the “fill handle” to get the result in all cells.

Method 5 – Merge SUBSTITUTE, LEN, CHAR, FIND, MID, and IFERROR Functions to Get Filename Without Extension from Path

Steps:

• Choose a cell (C5) to apply the formula-

• Enter the key and then drag the “fill handle” down.
• Within a moment, your output will be in your hands.

Method 6 – Create a User Defined Function to Get Filename from Path

Steps:

• Press Alt+F11 to open the “Microsoft Visual Basic for Applications”.

• Click the “Module” option from the “Insert” feature.

• In the module put the following code-

Function GetFileName(FullPath As String) As String
Dim List As Variant
List = VBA.Split(FullPath, "\")
GetFileName = List(UBound(List, 1))
End Function

• Without moving here and there, just save the code and minimize the VBA window.
• Choose a cell (C5), type your defined function within the cell, and put the cell (B5) inside the brackets of the defined function-

• Press Enter and drag down the “fill handle” to get the output inside the new column.

Method 7 – Apply VBA Code to Get Filename from Path

Steps:

• Press Alt+F11 to open the “Microsoft Visual Basic for Applications” window.

• Select “Module” from the “Insert” option.

• Inside the new module write the following code down and press the “Run” icon from the top ribbon-

Sub filePath()
Dim filename As String
Dim x As Variant
For Each cell In ActiveSheet.Range("B5:B11")
x = Split(cell.Value, Application.PathSeparator)
filename = x(UBound(x))
cell.Value = filename
Next cell
End Sub

• Get only the filename from the path in your Excel worksheet.

Things to Remember

In method 7, I have chosen a range (B5:B11) as I am applying the code for those cells. If you are applying the same VBA code don’t forget to change the cell range.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

<< Go Back to Excel File Name | Excel Files | Learn Excel