Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to add name of Sheet to a Column?
I am preparing to merge sheets in a workbook, before I do I need to find a
way to pull the sheet name into ColumnX so once merged I will retain the categorization. Is there a simple formula I can paste/fill-down into a column to do this? Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to add name of Sheet to a Column?
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
Success, click yes. -- Wag more, bark less "msnyc07" wrote: I am preparing to merge sheets in a workbook, before I do I need to find a way to pull the sheet name into ColumnX so once merged I will retain the categorization. Is there a simple formula I can paste/fill-down into a column to do this? Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to add name of Sheet to a Column?
Make sure the workbook has been saved (otherwise function won't work):
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,999) Copy down as needed. -- Best Regards, Luke M "msnyc07" wrote in message ... I am preparing to merge sheets in a workbook, before I do I need to find a way to pull the sheet name into ColumnX so once merged I will retain the categorization. Is there a simple formula I can paste/fill-down into a column to do this? Thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to add name of Sheet to a Column?
Watch it with that particular formula Brad.
With no cell reference it can lead to erroneous returns. See Bob Phillips' site for more info. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Tue, 25 May 2010 13:19:01 -0700, Brad wrote: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) Success, click yes. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to add name of Sheet to a Column?
You're correct, forgot to include the A1.
Thank you! -- Wag more, bark less "Gord Dibben" wrote: Watch it with that particular formula Brad. With no cell reference it can lead to erroneous returns. See Bob Phillips' site for more info. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Tue, 25 May 2010 13:19:01 -0700, Brad wrote: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) Success, click yes. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare sheet 1 column A numbers with sheet 2 column A number | Excel Worksheet Functions | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
A function that looks for a value on a sheet on unknown column or row | Excel Worksheet Functions | |||
how to use sumif function to check date in 1 sheet is < 2 sheet | Excel Worksheet Functions |