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. |
How to insert the tab name in a cell
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: Could anyone please tell how I add the tab name to a specifik cell in the excel shet. |
How to insert the tab name in a cell
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 "Kate Bj" <Kate wrote in message ... Could anyone please tell how I add the tab name to a specifik cell in the excel shet. |
inserting tab name into spreadsheet cell
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 |
All times are GMT +1. The time now is 07:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com