Earle Davis
Lurker
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?
=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?