Is there a formula to decode URL's?

Originally Posted by Kyle123

Here's the list if you fancy a formula:

Character	Escape Sequence
^	%5E
&	%26
`	%60
{	%7B
}	%7D
|	%7C
]	%5D
[	%5B
"	%22
<	%3C
>	%3E
\	%5C

Im not good with VBA so maybe im doing something wronmg. I created a macro with the first code you sent me but it does nothing am i missing this part of the code? Also I only need to decode a column of URL's not the entire workbook. Sorry if i sound dumb .

Richard the word By is not a constant in the URL strings.