Tab Names
 

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?

Tab Names
 

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

The formula above should all be on one line.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"sdmccabe" wrote:

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?