worksheet name

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I've read the previous "worksheet name" post.

I need a similar thing. I need to get the workbook name
in a cell but without this ".xls".

How could I get it?

Thanks
 
Hi
one way
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-5)
 
One way:

=MID(LEFT(CELL("filename",A1), FIND(".xls",CELL("filename",A1))-1),
FIND("[",CELL("filename",A1))+1,255)


Note that the workbook must be saved for this to work.
 
Thank you very much guys.
-----Original Message-----
One way:

=MID(LEFT(CELL("filename",A1), FIND(".xls",CELL ("filename",A1))-1),
FIND("[",CELL("filename",A1))+1,255)


Note that the workbook must be saved for this to work.

Alex said:
I've read the previous "worksheet name" post.

I need a similar thing. I need to get the workbook name
in a cell but without this ".xls".

How could I get it?

Thanks
.
 
Back
Top