How to insert the tab name in a cell

[Kate Bj]

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

 

[Jacob Skaria]

Try the below formula in a saved workbook.

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

If this post helps click Yes

 

[Ashish Mathur]

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

 

[Terry Hamal]

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 Ye
--------------
Jacob Skari

:

Previous Posts In This Thread:

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

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 Ye
--------------
Jacob Skari

:

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 functio

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

-
Regards

Ashish Mathu
Microsoft Excel MV
www.ashishmathur.com


Submitted via EggHeadCafe - Software Developer Portal of Choice
Understanding .NET
http://www.eggheadcafe.com/tutorial...469f-ab41-d4a6307f475a/understanding-net.aspx