| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Discussion (Misc queries) | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
| how do I insert the address of a selected cell into a fixed cell | Excel Discussion (Misc queries) | |||
| Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Linear Mode
