Solved! the incoming url string %C2%A0 translates to ChrW(160) , so replace(ListName, ChrW(160), " ") did the trick. Thanks everybody for pointing in the right direction.