1. Are you ready for the Galaxy S20? Here is everything we know so far!

Excel for Android not displaying tab name in cell

Discussion in 'Android Apps & Games' started by Earle Davis, Jan 27, 2016.

  1. Earle Davis

    Earle Davis Lurker
    Thread Starter

    With desktop Excel, I use the following formula to display the tab name in a given cell (this formula works in any cell):
    =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

    It displays fine with desktop Excel, but in Excel for Android it displays #VALUE!

    Does anyone have any idea how I can display the tab name in a cell for a file stored in the cloud and opened with Excel for Android? Also, do you know what causes the formula to display an error?
     



    1. Download the Forums for Android™ app!


      Download

       
Loading...
Similar Threads - Excel Android displaying
  1. BuckLikesAndroid
    Replies:
    6
    Views:
    166
  2. cidea
    Replies:
    3
    Views:
    178
  3. DaneWells91
    Replies:
    6
    Views:
    257
  4. RedHeadDev
    Replies:
    3
    Views:
    302
  5. Anirudha Deshpande
    Replies:
    0
    Views:
    194
  6. Milo Williamson
    Replies:
    5
    Views:
    538
  7. louis2008
    Replies:
    10
    Views:
    1,621
  8. OhioGuy59
    Replies:
    18
    Views:
    10,870
  9. DJR_Android
    Replies:
    4
    Views:
    3,401
  10. Samsung
    Replies:
    0
    Views:
    1,243

Share This Page

Loading...