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.

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.

Yes, both the last and first names are in separate fields.

Use ctrl+H, try to replace " "(spacebar or Alt+0032) with nothing.


Hope it helps


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=387571