View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default Cell equal to File Name

=MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename",A1 ))-FIND("[",CELL("filename",A1))-1)

This only works if you have saved the file at least once.

"Pedro Serra" wrote:

Is there a way to put the name of the excel file in a worksheet?

Thanks