GregFowler
New Member
- Joined
- Apr 18, 2002
- Messages
- 1
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.
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.