Pretty easy
=c1 & " "&d1 & " "& e1 & " "&f1

--
Don Guillett
SalesAid Software

"ohsix" wrote in message
...
I have the following columns in Excell 2007:

A=Year; B=Title; C=FirstName; D=MiddleName; E=LastName; F=Suffix;
G=Address;
H=City; I=State; J=ZIP.

I want to e able to combine cells so that the columns contain:
A=Year; B=Title FirstName MiddleName LastName Suffix; C=Address; D=Street,
City ZIP.

Can someone tell me *exactly* how to do this? I've tried following Help
using the " and & signs, using CONCATINATION (I don't understant any of
this)
but to no avail.

Thanks.

Keith