Is there a way to automatically insert a name label from the tab into a cell?
M Mike Scanlon Sep 10, 2004 #1 Is there a way to automatically insert a name label from the tab into a cell?
J Jack Schitt Sep 10, 2004 #2 =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.
=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.
