Editing Multiple Hyperlinks

[LeroyMac]

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?

[#2 · Accepted solution]

@LeroyMac 

You could use:

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

If no access to TEXTAFTER, then:

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

[#3]

The first one did the trick, but I've made a note of both. Thanks @Patrick2788!

[#4]

You're welcome!