As i mentioned in the comment to the question, it might be a carriage return or end of line sign.
The only way to find out what kind of char is at the end of string, is to use
ASCII
function, which return the ASCII code value.
SELECT ASCII(RIGHT(Remarks, 1)) AS LastCharAsciiCode
FROM TableName
Now, when you know what kind of char is there, you can update your table!
Or
You can replace all unwanted chars
update TableName set Remarks= REPLACE(REPLACE(REPLACE(Remarks,' ',''), CHR(10), ''), CHR(13), '')
Good luck!