How to display the document and current sheet names in Excel cells?? [Resolved]

Posted by Somu475 under Others on 12/14/2012 | Points: 10 | Views : 974 | Status : [Member] | Replies : 3
Hi All,

I want to display the Excel document name and current sheet name inside a cell in Excel.
Plz some one help me.

-Somu


Responses

Posted by: Dotnetrajanikanth on: 12/14/2012 [Member] Starter | Points: 50

Up
0
Down

Resolved
Hi,

Use the below formula for the document name.
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Use the below formula for the Sheet name.
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

these formulas should be written inside the respective cells.

Hope this helps


____________
www.flickr.com/photos/psdesigner/

Somu475, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Somu475 on: 12/14/2012 [Member] Starter | Points: 25

Up
0
Down
Thanks a lot... It's working fine...

-Somu

Somu475, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Dotnetrajanikanth on: 12/14/2012 [Member] Starter | Points: 25

Up
0
Down
its my pleasure :)

____________
www.flickr.com/photos/psdesigner/

Somu475, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response