More than 1 year has passed since last update.

Excel のシート名を表示する（ディレクトリ名に "]" がある場合にも対応）

Excel関数

Posted at 2021-07-30

結論

=MID(SUBSTITUTE(SUBSTITUTE(CELL("filename",A1),"\",""),"]","\",LEN(CELL("filename",A1))-LEN(SUBSTITUTE(CELL("filename",A1),"]",""))),FIND("\",SUBSTITUTE(SUBSTITUTE(CELL("filename",A1),"\",""),"]","\",LEN(CELL("filename",A1))-LEN(SUBSTITUTE(CELL("filename",A1),"]",""))))+1,31)

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up