worksheet name

[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

 

[Frank Kabel]

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)

 

[JE McGimpsey]

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]

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.

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

.