Combining Cell Info

[Guest]

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

 

[Don Guillett]

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

 

[Guest]

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)

 

[David McRitchie]

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/getstarted.htm#havemacro

 

[Guest]

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

I selected columns B thru F and wrote in the box where you put formulas:
=b1&" "&c1&" "&d1&" "e1&" "&f1

I still get a message that there's an error.

Keith

 

[Don Guillett]

Goto cell g1 (IF EMPTY) put in the formula>fill down

 

[Gord Dibben]

You missed the & before the E1

=b1&" "&c1&" "&d1&" "&e1&" "&f1


Gord Dibben MS Excel MVP