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: Francis on 11 Jan 2010 10:35 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.
From: Tom on 11 Jan 2010 11:23 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.
From: Daryl S on 11 Jan 2010 11:35 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.
From: Tom on 11 Jan 2010 11:37 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.
From: Eva on 11 Jan 2010 11:48
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. |