That will only trim the resultant value, not each individual value.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ric_deez" wrote in message
oups.com...
Hi Mully,

How are you building D2? If you do D2 = TRIM(A2&B2) you should not get
any spaces. You may not need a macro at all!!!

Regards,

Ric