Excel Tabs

[Optimuswicked]

Hi All,

If I have an excel tab called "John Doe" for example. Is there a formula I can put in cell A1 for example to use that name? and lets say later on i change the tab name to "Charles Gates" and then i would want A1 to update with that name (or any name i input for that matter).

Thank you again!

[protonLeah]

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

[Optimuswicked]

Awesome! thank you so much. It worked!

[Optimuswicked]

Hi Ben,

Do you know how to generalize the formula. For example, if say A1 had the above formula pull the name of another tab instead of the tab the formula is in (i.e the formula is in say sheet1 and the name we want is the name on tab 2) Thank you!

[protonLeah]

That's not possible. You would have to reference the other sheet in the formula. If you put that formula in several sheets, it will always display the name of the active sheet (i.e., the one being edited).