Formula for copying tap info into a cell
 

I know there is one, I just cannot remember what it is...I need a formula to
place the text on the tab of a worksheet into a designated cell in the same
worksheet.

Formula for copying tap info into a cell
 

=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,255)
--
Allllen


"James" wrote:

I know there is one, I just cannot remember what it is...I need a formula to
place the text on the tab of a worksheet into a designated cell in the same
worksheet.

Formula for copying tap info into a cell
 

You need a cell reference in the formula.......any cell will do.

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

See Bob Phillips' site for info on why.

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


Gord Dibben MS Excel MVP


On Thu, 9 Nov 2006 08:59:02 -0800, Allllen
wrote:

=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,255)