View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt[_33_] Matt[_33_] is offline
external usenet poster
 
Posts: 78
Default Question about filename formula ..


I found this formula, which was posted in 2004.

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


I wonder what does the cell A1 stand for? I removed it and it works
also ..

Matt