You can use the trim function i.e. if you have a value in cell A1 with
trailing blanks.
In B1 enter the formula =trim(A1)

"SAS" wrote:

How do I remove trailing blanks from numbers in order to use them in a formula?