Tab Names

[sdmccabe]

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?

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

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

 

[Gary L Brown]

=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
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

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?

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

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