excel取得sheet名稱函式

excel取得sheet名稱:

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

使用到的函數:

MID

CELL

FIND

相關參考網址:

http://www.frogjumpjump.com/2011/09/excel.html

http://isvincent.pixnet.net/blog/post/38415205-excel-%E5%8F%96%E5%BE%97%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%90%8D%E7%A8%B1

http://isvincent.pixnet.net/blog/post/42752116-excel-%E6%90%9C%E5%B0%8B%E5%A4%9A%E5%80%8B%E5%AD%97%E4%B8%B2(find%E3%80%81search)