remove the trailing space from the cell.

In a spare column you could use the formula =TRIM(D4)
then copy+paste special values back over D4.