Thread: How do i display the Filename without the path?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robert_manic robert_manic is offline
external usenet poster
  
Posts: 1
Default How do i display the Filename without the path?
I know you can display the full file name and path with the following formula:

=CELL("filename")

But how can you display the File name only? The path makes it so long that
the actual filename disappears off the sheet!
Reply With QuoteReply With Quote