#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 181
Default Formula Help

Sry... Yes I posted it twice as my computer looked like it timed out... I
should have checked

Thanks

"Jacob Skaria" wrote:

What about your previous post..??? Try the below formulas in a saved workbook

'Workbook and worksheet name
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1)),99)

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

'worksheet name
=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

If this post helps click Yes
---------------
Jacob Skaria


"Curtis" wrote:

Is there a formula that would allow the name of a workbook or worksheet to
show in a cell inside a worksheet?

Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"