Prev: RANDBETWEEN generating numbers outside range
Next: linking a sales receipt worksheet to an inventory worksheet
From: msnyc07 on 25 May 2010 15:46
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
From: Brad on 25 May 2010 16:19
=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
From: Luke M on 25 May 2010 16:20
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" <msnyc07(a)discussions.microsoft.com> wrote in message
news:9F9F4DD9-634E-45A3-8255-12B590AE69B1(a)microsoft.com...
>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


From: Gord Dibben on 25 May 2010 16:54
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 <Brad(a)discussions.microsoft.com>
wrote:

>=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
>
>Success, click yes.

From: Brad on 25 May 2010 17:46
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 <Brad(a)discussions.microsoft.com>
> wrote:
>
> >=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
> >
> >Success, click yes.
>
> .
>
 | 
Pages: 1
Prev: RANDBETWEEN generating numbers outside range
Next: linking a sales receipt worksheet to an inventory worksheet