excel url encode space to %20 code example
Example: excel vba How to URL encode a string
EncodedString = Application.EncodeUrl(String)
'Note: This requires Excel 2013 or newer
EncodedString = Application.EncodeUrl(String)
'Note: This requires Excel 2013 or newer