If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
SIMPLE CONCATENATE FUNCTION
=CONCATENATE(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. |
#12
|
|||
|
|||
SIMPLE CONCATENATE FUNCTION
Another option is to download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/morefunc/english/index.htm Alternate download site: http://www.download.com/Morefunc/300...-10423159.html This add-in contains many useful functions including a range concatenation function called MCONCAT. The formula would be: =MCONCAT(A1:A6," ") -- Biff Microsoft Excel MVP "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. |
#13
|
|||
|
|||
SIMPLE CONCATENATE FUNCTION
In cell A7
=A1&" "&A2&" "&A3&" "&A4&" "&A5&" "&A6 hth, -- Data Hog "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. |
#14
|
|||
|
|||
SIMPLE CONCATENATE FUNCTION
We can shorten your macro up by removing the loop...
Sub MakeSentence() Dim MC As Long MC = 1 'Column A Cells(1, MC + 1).Value = Join(WorksheetFunction.Transpose( _ Range(Cells(1, MC), Cells( _ Rows.Count, MC).End(xlUp))), " ") Columns(MC + 1).Columns.AutoFit End Sub -- Rick (MVP - Excel) "Don Guillett" wrote in message ... Macro solution Option Explicit Sub makesentence() Dim mc As Long Dim i As Long Dim ms As String mc = 1 'col A For i = 1 To Cells(Rows.Count, mc).End(xlUp).Row ms = ms & Cells(i, mc) & " " Next i 'MsgBox ms Cells(1, mc + 1) = ms Columns(mc + 1).Columns.AutoFit End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "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. |
#15
|
|||
|
|||
SIMPLE CONCATENATE FUNCTION
Rebecca --
=CONCATENATE(A1,B1,C1,D1,E1,F1) Worked for me with similar OS & Excel HTH "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. |
#16
|
|||
|
|||
SIMPLE CONCATENATE FUNCTION
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. |
#17
|
|||
|
|||
SIMPLE CONCATENATE FUNCTION
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. |
#18
|
|||
|
|||
SIMPLE CONCATENATE FUNCTION
=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. |
#19
|
|||
|
|||
SIMPLE CONCATENATE FUNCTION
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. |
#20
|
|||
|
|||
SIMPLE CONCATENATE FUNCTION
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. |
Thread Tools | |
Display Modes | |
|
|