You could avoid using VBa with this approach
If you need to keep the original URLs try this on a copy of your data
Find & Select > Replace.....
Find what:=
Replace with:= (enter a single space)
Replace all
Find what:=
Replace with:= (enter a single space)
Replace all
Then use Andys' formula
or to keep the result uniform
URL Encoding should always be three characters %??, hence the search string.
You could make use of this coding, but it would probably need VBa, by converting the URL Encoding to its' Ascii equivalent
e.g.
etc......
Hope this helps.
Bookmarks