DDE - Trailing Space

[BMI0776]

I am using DDE to write data to a EXCEL report template.  One of the columns is TEXT that is being used in  VLOOKUP formula in EXCEL.  When the column is written to EXCEL, there is a tailing space that is causing my data not to match.

For example, the value in my SAS data is "TEST123" but in EXCEL i see "TEST123 "

how to I tell SAS to remove that trailing SPACE.

Thanks,

[stat_sas]

Trim(Text)

[BMI0776]

If you mean add that to my SAS code, it already is. 

[stat_sas]

Not sure, found something seems close to your problem, where Tom has suggested a solution. May be helpful.

https://communities.sas.com/message/218009#218009