Hi, I am trying to solve a formula issue with Excel in Sharepoint. The formula is for retrieving the Sheet name value. It works fine when I open in "APP" . When I open in web version the formula does not work and gives me a #Value! error. Is there any workaround for this ? Thank you for any help and happy Thanksgiving
=MID(CELL("filename",A7),FIND("]",CELL("filename",B7))+1,31)
Last edited by Rick Vu; 11-24-2021 at 10:20 AM. Reason: adding on the formula
What is the formula?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
=MID(CELL("filename",A7),FIND("]",CELL("filename",B7))+1,31)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks