Cell value = tab name?

  • Thread starter Thread starter foxgguy2005
  • Start date Start date
F

foxgguy2005

is there a formula to put into a cell that will display the tab name in
the cell?
Thanks!
 
Try:

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

Manges
 
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

Reference the same cell based on tab name 1
Pulling Tab Name of a Different Tab Than What I'm Working In 7
How to get range names to Apply across multiple tabs 1
Naming of tabs from data in a worksheet 2
Find and return name of worksheet tab for referenced cell 2
Index Match on Columns and Rows 0
Min+Max from other Tabs 4
Return Tab Name 3

Back
Top