Report Builder and the TRIM function

Yahoo Archive
1
Has anyone figured out how to truncate or trim the "~" from a field? I have
the following calculated field set up TRIM(SalesRepList,~ ) and it is not
changing the result from what I get when using the salesreplist by itself.
Any ideas?

Thanks,

Jim Frice