SIMPLE CONCATENATE FUNCTION
in [Functions]
|
Prev: Excel 2007: Vlookup Problem
Next: Can I increase the view of a drop down list beyond 8 in Excel?
From: Bob Phillips on 11 Jan 2010 08:56 What is going on? Why are people posting with answers that were supplied hours, even days, ago? 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: "David Biddulph" groups [at] on 11 Jan 2010 09:13 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" <bob.phillips(a)somewhere.com> wrote in message news:e7gigXskKHA.2188(a)TK2MSFTNGP04.phx.gbl... > What is going on? Why are people posting with answers that were supplied > hours, even days, ago? > > 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: Paul C on 11 Jan 2010 09:17 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.
From: Joe User on 11 Jan 2010 09:26 "Bob Phillips" <bob.phillips(a)somewhere.com> 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 "@discussions.microsoft.com" or that the Message-ID is "@microsoft.com". 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" <bob.phillips(a)somewhere.com> wrote in message news:e7gigXskKHA.2188(a)TK2MSFTNGP04.phx.gbl... > What is going on? Why are people posting with answers that were supplied > hours, even days, ago? > > 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: Luke M on 11 Jan 2010 09:39
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. |