Thread: Insert file name in cell without .xls extension
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
  
Posts: 1,814
Default Insert file name in cell without .xls extension
I know that I can enter a cell file name with the following typed into the
cell:
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

But, can I do this without showing the file extension (.xls)?
Reply With QuoteReply With Quote