You must include a cell reference......any one will do.

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

For explanation see Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP

On Sun, 8 Mar 2009 21:14:01 -0700, Sheeloo <Click above to get my email id
wrote:

Try

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

in any cell...

"LinLin" wrote:

Hi Everyone

Is there any formula I can put in a cell so that it shows the tab/worksheet
name?

IE If my Tab name is "Supplier 1" I would like to have a cell in my
worksheet which says Supplier 1.
(Yes I'm lazy and hopefully there is a way to achieve this! Can't see the
point in typing it twice, risking typos etc...)

thanks!