Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to insert the tab name in a cell

8 views
Skip to first unread message

Bj@discussions.microsoft.com Kate Bj

unread,
Nov 22, 2009, 8:03:01 AM11/22/09
to
Could anyone please tell how I add the tab name to a specifik cell in the
excel shet.

Jacob Skaria

unread,
Nov 22, 2009, 8:13:01 AM11/22/09
to
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

Ashish Mathur

unread,
Nov 22, 2009, 10:58:08 AM11/22/09
to
Hi,

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

http://www.download.com/Morefunc/3000-2077_4-10423159.html

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Kate Bj" <Kate B...@discussions.microsoft.com> wrote in message
news:E001DBFA-D13A-42CC...@microsoft.com...

terryhamal

unread,
Dec 29, 2009, 4:44:40 PM12/29/09
to
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/3000-2077_4-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/aspnet/f13477c5-7887-469f-ab41-d4a6307f475a/understanding-net.aspx

0 new messages