Use a sheet name in a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FreddieP - 16 May 2008 15:15 GMT

Hi I would like a formula in a cell where I can show the sheet name.

For example

="2008 "&"Sheetname"

Anybody who knows?

Reply to this Message

Tom Hutchins - 16 May 2008 15:26 GMT

Try this...

="2008 " &
RIGHT(CELL("Filename"),LEN(CELL("Filename"))-FIND("]",CELL("Filename")))

The workbook must have been saved at least once for this to work.

Hope this helps,

Hutch

> Hi I would like a formula in a cell where I can show the sheet name.
>
[quoted text clipped - 3 lines]
>
> Anybody who knows?

Reply to this Message

Peo Sjoblom - 16 May 2008 15:34 GMT

That is not correct, you need to include a cell reference or else it will
switch sheet names
to the active sheet once the workbook is saved again.

Signature

Regards,

Peo Sjoblom

> Try this...
>
[quoted text clipped - 14 lines]
>>
>> Anybody who knows?

Reply to this Message

Marcelo - 16 May 2008 15:28 GMT

="2008 "&MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,256)

hth

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> Hi I would like a formula in a cell where I can show the sheet name.
>
[quoted text clipped - 3 lines]
>
> Anybody who knows?

Reply to this Message

Peo Sjoblom - 16 May 2008 15:30 GMT

="2008 "&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

A1 can be replaced by any cell reference even the cell that holds the
formula

Signature

Regards,

Peo Sjoblom

> Hi I would like a formula in a cell where I can show the sheet name.
>
[quoted text clipped - 3 lines]
>
> Anybody who knows?

Reply to this Message

FreddieP - 16 May 2008 15:40 GMT

I dont get it to work. And also I think that this will return the name of the
file. I want it to return the name of a specific sheet within the file.

Peo, could you perhaps write the formula in Swedish which I guess you are
when I see your name :)

/Freddie

> ="2008 "&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
>
[quoted text clipped - 8 lines]
> >
> > Anybody who knows?

Reply to this Message

Peo Sjoblom - 16 May 2008 15:55 GMT

I am Swedish but I don't have a Swedish Excel installed on the computer I am
at the moment,
The formula would be

="2008 "&EXTEXT(CELL("filename";A1);HITTA("]";CELL("filename";A1))+1;32)

in Swedish except that I don't remember if "filename" is changed to a
Swedish equivalent?

If you go to help and lookup the CELL function, what options are there, if
there is no "filename" replace it with
whatever the help example is using

Signature

Regards,

Peo Sjoblom

>I dont get it to work. And also I think that this will return the name of
>the
[quoted text clipped - 17 lines]
>> >
>> > Anybody who knows?

Reply to this Message

Gord Dibben - 16 May 2008 23:39 GMT

Freddie.

It works as Peo has written it.

I get 2008 Sheet1 when I enter the formula in any cell in Sheet1

Gord Dibben MS Excel MVP

>I dont get it to work. And also I think that this will return the name of the
>file. I want it to return the name of a specific sheet within the file.
[quoted text clipped - 16 lines]
>> >
>> > Anybody who knows?

Reply to this Message