Rebecca -

You can put this in cell A8:

=CONCATENATE(A1," ",A2," ",A3," ",A4," ",A5," ",A6)

This assumes you don't have the spaces in your cells and they must be
concatenated in.

If you have a lot of these, and the number of cells can be large, then you
could also do something like this is a column next to the cells:

in B1: =A1
in B2: =B1 & " " & A2

Then drag B2 down as far as you need. This will append all the words with
spaces between, and is much faster to create than the concatenate formula.



--
Daryl S


"Rebecca" wrote:

I apologize for asking such an incredibly newbie question, but I simply can't
get this to work, despite reading the help files and searching this forum. I
am using Windows 7 and newly purchased Excel 2007.

I have a column A with the following words (this is a simple, made-up
example): in

A1 The
A2 book
A3 is
A4 on
A5 the
A6 shelf.

I want to CONCATENATE them into one sentence in one cell. I can get
CONCATENATE to work in one row of cells in two or more columns, but I can't
get it to work in several rows of cells in the same column. Could you please
explain in detail how this can be done? Thanks.