Forum Discussion

LeroyMac's avatar
LeroyMac
Copper Contributor
Mar 21, 2023
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://axis-acbcompany.com/timeline?timeline_id=952954 

http://axis-acbcompany.com/timeline?timeline_id=953379 

http://axis-acbcompany.com/timeline?timeline_id=952480 

http://axis-acbcompany.com/timeline?timeline_id=953999 

http://axis-acbcompany.com/timeline?timeline_id=952955 

http://axis-acbcompany.com/timeline?timeline_id=952977  

 

To these but still have them hyperlinked to the URLs above? (they're the last 6 digits of the links above) ..... 

952954 

953379 

952480 

953999 

952955 

952977

 

Can I do this without clicking each individual cell and editing the hyperlink?

excel
Formulas and Functions
office 365
  • Patrick2788's avatar
    Patrick2788
    Mar 21, 2023

    LeroyMac 

    You could use:

     

    =HYPERLINK(A1,TEXTAFTER(A1,"="))

     

    If no access to TEXTAFTER, then:

    =HYPERLINK(A1,RIGHT(A1,6))

3 Replies

Resources