Formula to group First/Last names 2 one cell

[Bob Newman]

Excel 2003
I have 2 columns, A has last names B has first names. What is the formula
to merge them so column C will have the whole name (first name first, last
name second)?

 

[Max]

Data assumed in cols A and B, from row1 down
In C1: =TRIM(B1&" "&A1)
Copy down