Formatting Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spread sheet that someone else created. It has two columns one with
Last Name and the other with first name. I would like to combined both
together to make it into one without having to type all the names all over
again. What can i do?
 
With
Col_A containing Last Names (starting at cell A2)
Col_B containing First Names (starting at cell B2)

Try this:
C2: =B2&" "&A2
Copy that formula down as far as you need.

Example:
A2: Coderre
B2: Ron
C2 returns: Ron Coderre

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
If your names are in column A and B, you can use a formula like:

=a1&" "&b1
or
=b1&", "&a1

But whatever you do, don't delete those separate columns. It'll make working
with the names much easier if you use a different column for each field.

If you want, you can always hide the columns that you don't want to see.
 
I had the first names in column A and last names in column B. I used
the formula =CONCATENATE(A2," ",B2). You can then hide the 2 columns
with the first and last names in them.
 
Hi,

Try this:

=A1&" "&B1
suppose First Names are in column A and Last Names are in column B.

Thanks,
 
Back
Top