Thread: How to display the filename in spreadsheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RS RS is offline
external usenet poster
  
Posts: 113
Default How to display the filename in spreadsheet
Using the information for displaying a TAB-name,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
is there any way to display the FILENAME ONLY?

Thanks
Reply With QuoteReply With Quote