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

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

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

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

"Don Guillett" wrote:

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

Goto cell g1 (IF EMPTY) put in the formulafill down

--
Don Guillett
SalesAid Software

"ohsix" wrote in message
...
"Don Guillett" wrote:

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

You missed the & before the E1

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


Gord Dibben MS Excel MVP

On Tue, 29 May 2007 07:21:00 -0700, ohsix
wrote:

"Don Guillett" wrote:

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