Formula to group First/Last names 2 one cell
 

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

--
Thanks... Bob

Formula to group First/Last names 2 one cell
 

Data assumed in cols A and B, from row1 down
In C1: =TRIM(B1&" "&A1)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob Newman" wrote in message
...
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)?

--
Thanks... Bob