Looking for formula to change multiple links into URLs

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3137015%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ELooking%20for%20formula%20to%20change%20multiple%20links%20into%20URLs%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3137015%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%2C%20I%20have%20a%20huge%20list%20of%20hyperlinks%20and%20need%20a%20way%2Fformula%20preferred%20to%20change%20app%20400%20links%20into%20the%20URL.%20Appreciate%20the%20help%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3137015%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
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

@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.

 

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