LinkBack URL
About LinkBacks
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)))
Try this...
Formula:
Please Login or Register to view this content.
Or
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I like the replace function. Never thought of that way.
Thanks.
Tom
Glad it helps you and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks