help me to find a way to remove space without user intervention.

Hello,
I have an xls where user is populating single digit number or leter.

In some cases it apears that after the letter there is a space. Very often that is suggestion by excel which user is accepting and even does not realise that there is a space.
Leter on there is another file that is reading that data and is counting number of specific letter and when there is a spece behind it is not counted.

How this can be solved? I do not want to complicate reading formula by adding another condition (to count the letter with a space behind).
I do not also want to use some condition during data entry and to complicate the life of the user by appearing some warning msg.
Is there a way by VBA code or sth else those spaces to be trimmed on the background?

Thanks a lot!!!