Formula that returns the sheetname

T

TimT

Great Link! The formula was

=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255)

....yeah, like I was gonna figure that one out on my own.
 
Top