On Tue, 11 Mar 2008 11:50:08 -0700, FSt1
wrote:

2.assuming data is in column A and B....use this formula in Column C...
= A2 & " "& B2.

I would suggest

=TRIM(A2 & " " & B2)

in case there is nothing in B2

--ron