MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cell Name

Posted by Jonathan on March 07, 2001 12:24 PM

How can I make cell A3 show exactly what i have for the sheet name (what I have typed in the tab)?

Posted by ml on March 07, 2001 1:56 PM

There's probably a cleaner way, but this formula works:


Posted by Aladin Akyurek on March 07, 2001 3:12 PM


A1 =CELL("filename")

A3 =RIGHT(A1,LEN(A1)-(FIND("]",A1)))

Substitute CELL("filename") for A1 if you don't want to see the whole path.