Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Lv 55,333 points
A Friend
Favorite Answers4%
Answers1,869
Former Marine, Christian, Master Mason, Adult Sunday School / Bible Study Teacher. Let's get to the heart of the matter.
I have a formula that inserts the sheet tab name (#) into a cell in Excel but other formulas don't recognize there is a number in that cell?
=RIGHT(CELL("filename",D2),LEN(CELL,("filename",D2))-FIND("]",CELL("filename",D2))),
1 AnswerSoftware6 years ago