I have a file with more the 1000 names and addresses. My proble is that the
firat and last names are in 2 differents cells. I i would like to put it in
teh same cell. Is there anyway I csn do that?
Please help too many names to re-type
Carlos

Assuming that Column A contains the first name and Column B the last
name...

=A1&" "&B1

OR

=B1&", "&A1

....depending on your preference.

Hope this helps!

In article ,
"Hombreck" wrote:

I have a file with more the 1000 names and addresses. My proble is that the
firat and last names are in 2 differents cells. I i would like to put it in
teh same cell. Is there anyway I csn do that?
Please help too many names to re-type
Carlos

If you want FirstName LastName and the first names are in Column A and the
Last Names are in Column B...
Insert a new column to the right of Column B and put this formula in the
first cell:
=A1&" "&B1
Copy it down for all the names.
Then, copy the new list and Edit | Paste Special | Values.
If you want LastName, FirstName, the formula would be:
=B1&", "&A1

tj


"Hombreck" wrote:

I have a file with more the 1000 names and addresses. My proble is that the
firat and last names are in 2 differents cells. I i would like to put it in
teh same cell. Is there anyway I csn do that?
Please help too many names to re-type
Carlos

I only have one thing to say and that is THANK YOU VERY MUCH

"tjtjjtjt" wrote:

If you want FirstName LastName and the first names are in Column A and the
Last Names are in Column B...
Insert a new column to the right of Column B and put this formula in the
first cell:
=A1&" "&B1
Copy it down for all the names.
Then, copy the new list and Edit | Paste Special | Values.
If you want LastName, FirstName, the formula would be:
=B1&", "&A1

tj


"Hombreck" wrote:

I have a file with more the 1000 names and addresses. My proble is that the
firat and last names are in 2 differents cells. I i would like to put it in
teh same cell. Is there anyway I csn do that?
Please help too many names to re-type
Carlos

I only have one thing to say and that is THANK YOU VERY MUCH

"Domenic" wrote:

Assuming that Column A contains the first name and Column B the last
name...

=A1&" "&B1

OR

=B1&", "&A1

....depending on your preference.

Hope this helps!

In article ,
"Hombreck" wrote:

I have a file with more the 1000 names and addresses. My proble is that the
firat and last names are in 2 differents cells. I i would like to put it in
teh same cell. Is there anyway I csn do that?
Please help too many names to re-type
Carlos