Excelでセルにシート名を表示する

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]", CELL("filename",A1)))


▼参照元
https://www.moug.net/tech/exopr/0030051.html

Comments:0

Comment Form

Trackbacks:0

TrackBack URL for this entry
http://www.otogawa.com/cms/mt-tb.cgi/785
Listed below are links to weblogs that reference
Excelでセルにシート名を表示する from px*blog