Here is what I have used for Concatenating names but I am new to Excel so I
may not fully understand what you want.
---------------------------------------------------------------------------------------------------------------------
Where Cell C3 is the First Name and Cell B3 is the Last Name.

=CONCATENATE(C3," ",B3)

Will yield..............FirstName LastName
----------------------------------------------------------------------------------------------------------------------
Where Cell B3 has the Last Name and Cell B3 has the First Name.

=CONCATENATE(B3,", ",C3)

Will yield.............LastName, FirstName

-----------------------------------------------------------------------------------------------------------------------

Linda

"Metalteck" wrote in message
...
How do I get a space between the first name and last name using the trim
command?

"JE McGimpsey" wrote:

One way:

=TRIM(A1 & B1)

In article ,
Metalteck wrote:

Yes, there seems to be spaces. Is there a command I can use to trim
them down?