Combining Cell Info

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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
 
Don Guillett said:
Pretty easy
=c1 & " "&d1 & " "& e1 & " "&f1
Click to expand...

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
 
You missed the & before the E1

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


Gord Dibben MS Excel MVP
 
Back
Top