Can I display the name of a tab in a given cell?

Hello sdmccabe,

Type the following formula:

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

Exactly as is written but on 1 line

Judith
--
Hope this helps


"sdmccabe" wrote:

Can I display the name of a tab in a given cell?

Thanks for the formula. I tried to copy and paste into a cell and Excel
advised the formula contained an error, highlighting the the following
portion:

CELL("filename"

Did I do something wrong?


"JudithJubilee" wrote:

Hello sdmccabe,

Type the following formula:

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

Exactly as is written but on 1 line

Judith
--
Hope this helps


"sdmccabe" wrote:

Can I display the name of a tab in a given cell?

Try this =MID(CELL("filename"), FIND("]",CELL("filename"))+1,
LEN(CELL("filename"))-FIND("]", CELL("filename")))


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=525536

That won't work, do as follows


1. Enter the formula in a cell on Sheet1

2. enter the same formula in Sheet2

3. Go back to Sheet1, it now says Sheet2

you need to add a cell reference

=MID(CELL("filename",A1),
FIND("]",CELL("filename",A1))+1,LEN(CELL("filename".A 1))-FIND("]",
CELL("filename",A1)))

also this part

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

is really obsolete, since a sheet name can only contain 31 characters you
can use

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



--

Regards,

Peo Sjoblom





"intruder9" wrote
in message ...

Try this =MID(CELL("filename"), FIND("]",CELL("filename"))+1,
LEN(CELL("filename"))-FIND("]", CELL("filename")))


--
intruder9
------------------------------------------------------------------------
intruder9's Profile:
http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=525536