Thread: How to display the filename in spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default How to display the filename in spreadsheet
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