Excel function

[Mike Scanlon]

Is there a way to automatically insert a name label from
the tab into a cell?

 

[Jack Schitt]

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1))

assuming I read the question correct.
You might want to use INDIRECT("A1") instead of A1 to protect against
deletion of row 1. Or you can use the cell reference that contains the
calling formula.

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[Guest]

Thanks very much - it works great - exactly what I want!