Two different cells

H

Hombreck

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
 
D

Domenic

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!
 
T

tjtjjtjt

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
 
Top