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.
