Combining text cells with spaces in between them

[GregFowler]

I am trying to pull from a separate sheet the first and last name which are in different cells. I know how to combine them into one cell, but I am not sure how to add a space so that the name looks proper.

I am also running into a similar situation with the addresses. I want to pull the city and then have a comma, then space, then the state, then comma and then the zip code.
I am sure that this is simple, but I am new to Excel. Any help would be appreciated. Thanks.

 

[Mark W.]

=A1&" "&B1

Or...

=CONCATENATE(A1," ",B1)

 

[Yogi Anand]

On 2002-04-19 09:28, GregFowler wrote:
I am trying to pull from a separate sheet the first and last name which are in different cells. I know how to combine them into one cell, but I am not sure how to add a space so that the name looks proper.

I am also running into a similar situation with the addresses. I want to pull the city and then have a comma, then space, then the state, then comma and then the zip code.
I am sure that this is simple, but I am new to Excel. Any help would be appreciated. Thanks.

to add a space between FirstName and LastName use

=FistName&" "&LastName