How to display the document and current sheet names in Excel cells?? [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

Thanks a lot... It's working fine...

-Somu

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

its my pleasure :)

____________
www.flickr.com/photos/psdesigner/

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