Return the workbook name from a full path

	A
1	Book1.xls
2	C:\Temp\BetterSolutions.xls
3	C:\Temp\SubFolder\Another Folder\Workbook_Name.xls
4	=MID(A1,FIND("#",SUBSTITUTE("\"&A1,"\","#",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))+1)),LEN(A1))="Book1.xls"
5	=MID(A2,FIND("#",SUBSTITUTE("\"&A2,"\","#",LEN(A2)-LEN(SUBSTITUTE(A2,"\",""))+1)),LEN(A2))="BetterSolutions.xls"
6	=MID(A3,FIND("#",SUBSTITUTE("\"&A3,"\","#",LEN(A3)-LEN(SUBSTITUTE(A3,"\",""))+1)),LEN(A3))="Workbook_Name.xls"

Built-in Functions

MID - The characters from the middle of a text string.
FIND - The starting position of a substring within a larger text string.
SUBSTITUTE - The text string after replacing instances of a substring.
LEN - The number of characters in a text string.