Forum Discussion
Solved
Editing Multiple Hyperlinks
Hello, when exporting a report to excel, the first column gives me the link to the page within the system I access my "task". (below are dummy links). How do i convert these ..... http://axi...
You could use:
=HYPERLINK(A1,TEXTAFTER(A1,"="))If no access to TEXTAFTER, then:
=HYPERLINK(A1,RIGHT(A1,6))
You could use:
=HYPERLINK(A1,TEXTAFTER(A1,"="))
If no access to TEXTAFTER, then:
=HYPERLINK(A1,RIGHT(A1,6))- The first one did the trick, but I've made a note of both. Thanks Patrick2788!
- You're welcome!
