Ric,

Read the Help on TRIM, it says ... Removes all spaces from text except for
single spaces between words ... Thus, if either A1 or B1 has a trailing or
leading space, it creates a single space in the A1&B1, which doesn't get
trimmed. Or

A1: Bobspace
B1:space Ric

=TRIM(A1&B1) = BobspaceRic
=TRIM(A1)&TRIM(B1) = BobRic

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ric_deez" wrote in message
ups.com...
Hi Bob,

Maybe it is getting late in the day in my corner of the woods but I
fail to see how trim(A&B) and trim(A)&trim(B) would not always return
the same result, afterall all we are doing is getting rid of the
spaces... If we were talking about LTRIM, then I would understand...

Ric