EXCEL| 파일명 표시하기

* File Path + [File Name] + Sheet Name:

=Cell("filename")

C:\Documents\[sample.xlsx]sheet1

* File Name:

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

sample.xlsx

#참조

https://support.microsoft.com/en-us/kb/323225