The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Excel URL Special Character Encoding
solsovly
Registered User regular
Registered User regular
Is there a built in function to replace special characters for encoding URLs in Excel?
I can do one offs like =substitute(cell," ","%20") for spaces, but I want to cover all the special characters. For a list of special characters see (http://www.tcpipguide.com/free/t_URLGeneralSyntax-4.htm)
I know I can do a very giant, ugly nested substitute line but was hoping there was a built in function. VBA is less ideal and only a last resort, but not completely off on the idea.
Thanks for the help H/A.
I can do one offs like =substitute(cell," ","%20") for spaces, but I want to cover all the special characters. For a list of special characters see (http://www.tcpipguide.com/free/t_URLGeneralSyntax-4.htm)
I know I can do a very giant, ugly nested substitute line but was hoping there was a built in function. VBA is less ideal and only a last resort, but not completely off on the idea.
Thanks for the help H/A.
solsovly on
0
Posts