Combine First and Last Name colums to create thrid column of full

[Guest]

What is the formula to combine a2 and b2 to display in c2

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

 

[Ron Coderre]

Try this:

C2: =A2&" "&B2

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

Regards,

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

 

[Guest]

That worked as well, again, thank you for your assistance.

 

[Ron Coderre]

You're welcome, Mark.......I'm glad I could help.
--------------------------

Regards,

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