Function to add name of Sheet to a Column?

[msnyc07]

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

 

[Brad]

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

Success, click yes.

 

[Luke M]

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.

 

[Gord Dibben]

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

 

[Brad]

You're correct, forgot to include the A1.

Thank you!
--
Wag more, bark less

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

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

Success, click yes.

.