need a shortcut for naming a tab/ refer. tab name in formula

[xlgooroo]

I have 2 questions in 1:

1) Is there a shortcut for naming a tab (worksheet) other than double clicking on the tab itself?

2) Can you reference a tab name in a formula as text? In other words I might have a concatenate formula (using &s instead of concatenate) where I want part of the resulting text to be the tab name.

e.g. tab name is "Ed", cell a1="Mr."
formula -> =a1&" "&"Ed" manually typed. How can I replace "Ed" with a reference to the tab name?

Thanks in advance!
xlgooroo

 

[Oaktree]

1) ALT O/ H/ R

2) =A1&" "&REPLACE(CELL("filename",A1),1,SEARCH("]",CELL("filename",A1)),"")

 

[xlgooroo]

Thanks - those both worked great!