why not use the array formula
try:
=SUBSTITUTE(URL,{"%20","%3A","%5C"},{" ",":","\"})
HTH

--
Regards,

Sebation.G

groups.com...
Is there a better way to unescape a URL? For now I'm getting by with
this but I'd like something more generic.

Thanks.

Function unescape(s As String)
s = Application.Substitute(s, "%20", " ")
s = Application.Substitute(s, "%3A", ":")
s = Application.Substitute(s, "%5C", "\")
unescape = s
End Function