As you are importing from HTML to excel try adding a non-breaking space to the end of the value. E.g.
rHTML += "<td>" & dr("vRequisition") & " </td>"
I'm very surprised that the single quote character was visible - that is not standard Excel behaviour. I did notice that the character in your code was
‘
and not
'
. (Edit - the character is not copying across now! You can see the character in your question though) That might be a feature of the formatting here or from your system, but to overcome that use the single quote ascii code explicitly e.g.
rHTML += "<td>'" & dr("vRequisition") & "</td>"
The second suggestion is more "excel-like"