View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 698
Default Formatting Columns

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


"Jessica" wrote:

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?