Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be 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.

Trending News

Promoted
A Friend
Lv 5
A Friend asked in Computers & InternetSoftware · 6 years ago

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))),

Update:

Thank you sooo much! God Bless!

1 Answer

Relevance
  • expletive_xom
    Lv 7
    6 years ago
    Favorite Answer

    If the Tab Name is a number then put VALUE() around your formula.

    this should work with a copy&paste

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

    but only if your Tab name is something like 2

    let me know.

    your original formula has an extra comma after the 2nd CELL

Still have questions? Get your answers by asking now.