|
Q: Ken Fernandez A: The actual string "filename" is the required parameter. For example, this formula might return something like C:\WINDOWS\Desktop\[Budget.xls]Sheet2. Getting Excel to return only the sheet name requires a more complex formula that strips off everything except the name of the sheet: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename"))-FIND("]",CELL("filename"))) |
Category:Spreadsheets Issue: July 2000 |
These Web pages are produced by Australian PC World © 2000 IDG Communications