Thread: How do i display the Filename without the path?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default How do i display the Filename without the path?
Hi Robert

See
http://www.xldynamic.com/source/xld.xlFAQ0002.html


--
Regards Ron de Bruin
http://www.rondebruin.nl



"robert_manic" wrote in message ...
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