Looking for formula to change multiple links into URLs

New Contributor

Hi, I have a huge list of hyperlinks and need a way/formula preferred to change app 400 links into the URL. Appreciate the help

2 Replies


Without using VBA, no, there's no way to do this.

How to change multiple hyperlink paths at once in Excel?


or make at own the steps...here the instructions

- Make a backup copy of the file

- Right click on the table tab

- show code

- Paste this code:


Private Sub Test()
Dim H A's hyperlink
For Each H In Me.Hyperlinks
H.Address = Replace(H.Address, "\Intern\falli\", "\Intern\EXPORT_IMPORT\falli\")
end sub



- Click anywhere in the sub with the cursor

- Press F5 (you can't see anything, the mouse pointer may turn into an hourglass, wait)

- VBA editor too

- Save file


Hope I was able to help you with this info.



I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.


@NikolinoDE   thanks for all the info. Will take a a closer look and try to get it done this way.