How do i display the Filename without the path?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...


Try this formula:

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


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

Bruno
 
Back
Top