Extracting names of Worksheets without Macros

[fitzt70]

The following formula works. Is there a more elegant way of doing this?

=RIGHT(CELL("filename",Sheet2!$A$1),LEN(CELL("filename",Sheet2!$A$1))-FIND("]",CELL("filename",Sheet2!$A$1)))

[:) Sixthsense :)]

Try this...

=MID(CELL("filename",sheet2!$A$1),FIND("]",CELL("filename",sheet2!$A$1))+1,255)

Or

=REPLACE(CELL("filename",sheet2!$A$1),1,FIND("]",CELL("filename",sheet2!$A$1)),"")

[fitzt70]

I like the replace function. Never thought of that way.

Thanks.

Tom

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback