Looking for formula to change multiple links into URLs

Markus_Richert 

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\")
Next
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.

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.