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: ryguy7272 on 11 Jan 2010 01:16 Maybe this: =A1&A2&A3&A4&A5&A6 Select the range and hit F4, you'll get this: =$A$1&$A$2&$A$3&$A$4&$A$5&$A$6 Look in the help files, or on Google, for 'Absolute Reference'. -- Ryan--- If this information was helpful, please indicate this by clicking ''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: Ron on 11 Jan 2010 02:49 Rebecca don't quite understand your problem. Presumably your using: =CONCATENATE(A1," ",A2," ",A3," ",A4," ",A5," ",A6) or =A1&" "&A2&" "&A3&" "&A4&" "&A5&" "&A6 Please explain how this will not work in any cell that you copy it to !? "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: JLatham on 11 Jan 2010 07:53 =CONCATENATE(A1, " ", A2, " ", A3," ",A4," ",A5," ",A6) or =A1 & " " & A2 & " " & A3 & " " & A4 & " " & A5 & " " & A6 "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: Eduardo on 11 Jan 2010 08:12 Hi, try =A1&" "&A2&" "&A3&" "&A4&" "&A5&" "&A6 if this helps please click 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: Eduardo on 11 Jan 2010 08:24
Hi, try =A1&" "&A2&" "&A3&" "&A4&" "&A5&" "&A6 "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. |