Excel function

  • Thread starter Thread starter Mike Scanlon
  • Start date Start date
M

Mike Scanlon

Is there a way to automatically insert a name label from
the tab into a cell?
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotals in Excel 2007 TABLES 1
Logical Test with multiple cells 2
naming cells using insert > name> define 2
Formula, Macro, or VBA code to find and insert 3
Insert file and tab name from list into formula 1
Function Syntax not showing - xnpv 1
One step paste of XLS file name in one of its own cells 2
Formula to lookup worksheet label 3

Back
Top