The following formula works. Is there a more elegant way of doing this?
=RIGHT(CELL("filename",Sheet2!$A$1),LEN(CELL("filename",Sheet2!$A$1))-FIND("]",CELL("filename",Sheet2!$A$1)))
The following formula works. Is there a more elegant way of doing this?
=RIGHT(CELL("filename",Sheet2!$A$1),LEN(CELL("filename",Sheet2!$A$1))-FIND("]",CELL("filename",Sheet2!$A$1)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks