View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Combine First and Last Name colums to create thrid column of full

Try this:

C2: =A2&" "&B2

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Mark M" wrote in message
...
What is the formula to combine a2 and b2 to display in c2

A2 = First Name
B2 = Last Name
C2 = formated Full Name