If you are going to do this often, you might want to use a macro.
See join in
http://www.mvps.org/dmcritchie/excel/join.htm#join
but probably not enough of an incentive unless you had some more
macros that you needed. There are others on the page that you
could probably need to use sometime in the near future and many
are on the same page and such a macro would be the "TrimALL"
macro which would certainly be worth the effort of using macros.

To install a macro that you have the code for see
http://www.mvps.org/dmcritchie/excel....htm#havemacro

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JMB" wrote in message ...
In case some of those cells are empty and the OP wants to clean up some of
the extra spaces:

=TRIM(c1&" "&d1&" "&e1&" "&f1)



"Don Guillett" wrote:

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