Prev: Excel 2007: Vlookup Problem
Next: Can I increase the view of a drop down list beyond 8 in Excel?
From: Rebecca on 9 Jan 2010 05:51
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.
From: Bob Phillips on 9 Jan 2010 06:15
I am probably mis-understanding, but

=A1&" "&A2&" "&A3&" "&A4&" "&A5&" "&A6

HTH

Bob

"Rebecca" <Rebecca(a)discussions.microsoft.com> wrote in message
news:BEA2E257-D2CB-404A-A393-42AD346933E7(a)microsoft.com...
>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.


From: Gary''s Student on 9 Jan 2010 06:20
=A1 & " " & A2 & " " & A3 & " " & A4 & " " & A5 & " " &A6

--
Gary''s Student - gsnu200909


"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.
From: trip_to_tokyo on 9 Jan 2010 06:38
Put this is cell A 7:-

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

If my comments have helped please hit Yes.

Thanks!

"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.
From: trip_to_tokyo on 9 Jan 2010 06:47

Type this into cell A 7:-

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

If my comments have helped please hit Yes.

Thanks.


"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.
 |  Next  |  Last
Pages: 1 2 3 4 5 6 7
Prev: Excel 2007: Vlookup Problem
Next: Can I increase the view of a drop down list beyond 8 in Excel?