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

=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

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

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.

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.

.