File Name & Formula

Filename formula
	There may be times when you need to insert the name of the current workbook
	or worksheet in to a cell.
	This can be done by using the CELL() function, shown below.
	C:\Documents and Settings\Sajid\My Documents\Dropbox\excel files\[Excel function TUTOR1.XLS] Filename formula
	=CELL("filename")
	The problem with this is that it gives the complete path including drive letter and folders.
	To just pick out the workbook or worksheet name you need to use text functions.
	To pick the Path.
	C:\Documents and Settings\Sajid\My Documents\Dropbox\excel files\
	=MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)
	To pick the Workbook name.
	Excel function TUTOR1.XLS
	=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)
	To pick the Worksheet name.
	Filename formula
	=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)