SIMPLE CONCATENATE FUNCTION

What is going on? Why are people posting with answers that were supplied
hours, even days, ago?

Bob

"Rebecca" wrote in message
...
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.

It appears that they are using some thoroughly unreliable web interface to
the newsgroup, and my guess is that they are not seeing the answers that
those of us accessing the newsgroup by more reliable means can send and see.

If Microsoft can't provide a reliable link between their web server and
their news server, it would be easier if they were to separate the two
systems completely, and then those who prefer to use a web forum could use
that, and those who prefer the newsgroup could use this.
--
David Biddulph

"Bob Phillips" wrote in message
...
What is going on? Why are people posting with answers that were supplied
hours, even days, ago?

Bob

"Rebecca" wrote in message
...
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.

You need to identifiy each item

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

For spaces, you need to include them also

=CONCATENATE(A1," ",A2," ",A3," ",A4," ",A5," ",A6," ",A7," ")
--
If this helps, please remember to click yes.


"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.

"Bob Phillips" wrote:
What is going on? Why are people posting with answers
that were supplied hours, even days, ago?

Take a look at my thread "FYI: MSDG not displaying posts;...". Ignore
Peter's comments; he did not understand the problem. But some of my later
response refine the details of the problem.

I'm not sure which postings your are complaining about. But if you look at
the actual "source" of the posting, you might see that the From address is
" or that the Message-ID is ".
Either indicates that it was submitted using the MS Discussion Groups web
interface. Such is the case for some of the more recent postings that I
looked at in this thread.

FYI, the MSDG web interface is still broken as of the time of this response,
more than 48 hours later.


----- original message ------

"Bob Phillips" wrote in message
...
What is going on? Why are people posting with answers that were supplied
hours, even days, ago?

Bob

"Rebecca" wrote in message
...
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.

Use the amperand (&) to string things together. In your example, something
like:

=A1&" "&A2&" "&A3&" "&A4&" "&A5&" "&A6
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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.

Hi

Using the Excel's Concatenate function, try this

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

Normally, I use the & to concatenate, in your case which will be

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

--
Hope this help

Please click the Yes button below if this post have helped in your needs

Thank You

cheers, francis





"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.

Try this:
=CONCATENATE(A1,A2,A3,A4,A5,A6)

All it does is add the values in all the specified cells.



"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.

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.

Try:

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

It combines the values of all the specified cells.

"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.

Please try this
=CONCATENATE(A1," ",A2,," ",A3," ",A4," ",A5," ",A6)
Click yes if helped
--
Greatly appreciated
Eva


"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.