Perhaps the source of your data included non-breaking spaces (e.g., in a
browser):

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

In article ,
dstiefe wrote:

my "trim" function is not working.. any thoughts on that?