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:

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

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

Try:

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.