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

Regards,

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

"Mark M" wrote in message
...
That worked as well, again, thank you for your assistance.

"Ron Coderre" wrote:

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