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?
|