Parse/Extract File Name from Full File Name and Path

NEW! More Books..

Add Excel Answers & Search To Your Google Toolbar Details

Current Special! Complete Excel Excel Training Course for Excel 97 - Excel 2003, only ~~$145.00~~. $59.95 Instant Buy/Download, 30 Day Money Back Guarantee & Free Excel Help for LIFE!

Back to: Excel Custom Function/Formulas . Got any Excel/VBA Questions? Free Excel Help

This UDF will extract the file name from a full path name

The Code

Function FunctionGetFileName(FullPath As String)
Dim StrFind As String
	Do Until Left(StrFind, 1) = "\"
		iCount = iCount + 1
		StrFind = Right(FullPath, iCount)
			If iCount = Len(FullPath) Then Exit Do
	Loop
	
	FunctionGetFileName = Right(StrFind, Len(StrFind) - 1)
	
End Function

To use this UDF push Alt+F11 and go Insert>Module and paste in the code. Push Alt+Q and save. The Function will appear under "User Defined" in the Paste Function dialog box (Shift+F3).

Enter the function like this.

=FunctionGetFileName(A1)

Where A1 contains you file and path name.

Excel Dashboard Reports & Excel Dashboard Charts 50% Off

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft Ž and Microsoft Excel Ž are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft