Skip to content

Instantly share code, notes, and snippets.

@motoraku

motoraku/file_sheet_name_4.txt

Created December 13, 2015 10:39
Show Gist options
  • Save motoraku/c3b453f5475dfe46905b to your computer and use it in GitHub Desktop.
Save motoraku/c3b453f5475dfe46905b to your computer and use it in GitHub Desktop.
Download ZIP
エクセル関数でファイル名・シート名を表示#3 : Show file name or sheet name by Excel function #3
Raw
file_sheet_name_4.txt
=RIGHT(CELL("FILENAME",$A$1),LEN(CELL("FILENAME",$A$1))-FIND(CHAR(9),SUBSTITUTE(CELL("FILENAME",$A$1),"]",CHAR(9),LEN(CELL("FILENAME",$A$1))-LEN(SUBSTITUTE(CELL("FILENAME",$A$1),"]","")))))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment