View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ohsix ohsix is offline
external usenet poster
 
Posts: 6
Default Combining Cell Info

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