Last Name & First Name

S

Susan

I have Excel 2003. Is the a way to combine two columns
Last Name and First Name to make a Name field where the
First Name and Last Name are just separated by a space
for printing a list?

Thanks for information.
Susan
 
C

CC

Yes there is - I like this feature. Create a blank column
to consolidate the two columns. Under Function, use
CONCATENATE. In Text 1, put the cell number, in Text 2-
space, in Text 3, the next cell number. Remember, you
will need to have a field for the space or there won't be
one.
HTH
 
B

Biff

Hi Susan!

Use a helper column to do this. Do you want to swap the
order of the names? From Last First to First Last?

Assume the Last names are in column A, A1:A100.
First names are in column B, B1:B100.
In C1 enter this formula and copy down or just double
click the fill handle:

=B1&" "&A1

Now, get rid of the formulas and make the names constants:

Select C1:C100.
Right click and select Copy.
Right click again and select Paste Special>Values.

Now you can delete columns A and B if you want.

Biff
 
G

Gord Dibben

Susan

Assuming First name in Column A and Last name in Column B

In a third column enter = B1 & " " & A1

Gord Dibben Excel MVP
 
Top