can i copy a tab name into a field

[Chip Pearson]

Try the following formula:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

The file must have been saved for this to work.

Also, please ask your question in the body of the message, not
the subject line. Subject lines get truncated.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

RP
(remove nothere from the email address if mailing direct)