Hi Metalteck-

Do you have any idea where these 'spaces' are coming from? I have tried to
replicate the issue as you describe it and can't even force data from Access
hold any trailing spaces.

Are the first & last names in separate fields/columns? How are you
'concatenating' the data?

Regards |:)
"Metalteck" wrote:

I copy and paste results from a query in access to excel. For example, the
first and last name of a person. When I try to concatenate the two names in
excel, I get extra spaces behind each name. Is there a way I can get rid of
those spaces, so that when I concatenate, it would look normal.