Formula worked like a charm, thank you so much for saving me endless hours of repetitive typing!



Jacob Skaria wrote:

Try the below formula in a saved workbook.
22-Nov-09

Try the below formula in a saved workbook.

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

If this post helps click Yes
---------------
Jacob Skaria


"Kate Bj" wrote:

Previous Posts In This Thread:

On Sunday, November 22, 2009 8:03 AM
Kate Bj wrote:

How to insert the tab name in a cell
Could anyone please tell how I add the tab name to a specifik cell in the
excel shet.

On Sunday, November 22, 2009 8:13 AM
Jacob Skaria wrote:

Try the below formula in a saved workbook.
Try the below formula in a saved workbook.

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

If this post helps click Yes
---------------
Jacob Skaria


"Kate Bj" wrote:

On Sunday, November 22, 2009 10:58 AM
Ashish Mathur wrote:

Hi,You may download and install this addin and then use the sheetname
Hi,

You may download and install this addin and then use the sheetname function

http://www.download.com/Morefunc/300...-10423159.html

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com


Submitted via EggHeadCafe - Software Developer Portal of Choice
Understanding .NET
http://www.eggheadcafe.com/tutorials...nding-net.aspx