=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