Thread: How to display the filename in spreadsheet
View Single Post
  #3   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
Thank you for the link.

"JE McGimpsey" wrote:

See
http://www.mcgimpsey.com/excel/formu..._function.html

In article ,
RS wrote:

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?

Reply With QuoteReply With Quote