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!

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!

How do i display the Filename without the path?
 

On Wed, 11 Oct 2006 09:13:02 -0700, robert_manic
wrote:

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!


Try this formula:

=MID(CELL("filename"),FIND("[",CELL("filename"))+1,
FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)


--ron

How do i display the Filename without the path?
 

Did you try in View, Header and footer, User Header, 7th button from
the left? Can it be useful?

Bruno