I have an excel with some variables that have come to me from a URL and they are encoded, how can I decode them? I don't care if it's with formulas or with VBA, although I don't know how to insert these VBAs correctly so that they work. I have tried to insert a script that I have found on the internet in the DEVELOPER tab and have not achieved anything except some errors.
In Excel there is no function to decode URLs, but it is possible with a custom function, install a third-party plugin or use the substitute command:
Using a custom VBA function
Source: https://www.ilovefreesoftware.com/19/tutorial/how-to-bulk-decode-urls-excel.html (nice tutorial with images)
With third-party plugins
Source: SeoTools (needs installation)
=UrlDecode(your_text_here)
With the REPLACE command (in English SUBSTITUTE)
Source: https://searchmarketingcorner.wordpress.com/2013/03/27/creating-an-excel-formula-to-encode-or-unencode-urls/