Single quote from Input excel cell value changed as Question Mark after using it formula

[Parthasarathi]

HI All,

I am getting few string from a excel sheet and trying to convert to a different column. This is working fine and when I have a single quote in the input string that is changed ? in the output. 

In the formula tool I have tried the below

if(Contains(ToString([Username]),CharFromInt(39))) then
ToString(""+ ToString([Username])+"")
else
ToString(""+ ToString([Username])+"")
EndIf

Sample input: M’User Services 

Current output: M?User Services 

Expected output: M’User Services 

[PhilipMannering]

Does this work?

replacechar([Username], '’?', "’")

This will replace all ’ and ? with an apostrophe.