Can somebody please advise what to do about the folliwing

For example I have a value in a field "DO" which in some instances also has
a space at the end.

Filter on the column ignores the space, but sort picks up the space.

Thanks
JulieG