![]() |
CONCATENATE
I would LOVE to combine cells from the same column instead of cut & pasting
information. - example D132 through D147 and have this combined information appear in D132. Is this possible? |
CONCATENATE
"Tservo" wrote:
I would LOVE to combine cells from the same column instead of cut & pasting information. - example D132 through D147 and have this combined information appear in D132. Is this possible? =D132 & D133 & ... & D146 & D147 You can separate the cell contents by concatenating strings. for example: =D132 & " " & D133 & ... & D146 & " " & D147 Obvious, this is tedious for a large range like D132:D147. The CONCATENATE function does not accept ranges either. |
CONCATENATE
Simple form...........
In D131..............not D132! =D132&D133&D134&D135 etc. Not so simple form.............. =D132 $ " " D133 & " " & D134 etc. Easy way.............use a UDF Function ConCatRange22(CellBlock As Range, Optional Delim As String = "") _ As String 'entered as =concatrange22(a1:a10,", ") desired delimiter between quotes 'as written delimiter is comma space Dim Cell As Range Dim sbuf As String For Each Cell In CellBlock.Cells If Cell.text < "" Then sbuf = sbuf & Cell.text & Delim End If Next Cell ConCatRange22 = Left(sbuf, Len(sbuf) - Len(Delim)) End Function Paste the UDF to a General module in your workbook. Gord Dibben MS Excel MVP On Thu, 15 Apr 2010 11:38:01 -0700, Tservo wrote: I would LOVE to combine cells from the same column instead of cut & pasting information. - example D132 through D147 and have this combined information appear in D132. Is this possible? |
CONCATENATE
Hi,
Download and install this addin - http://www.download.com/Morefunc/300...-10423159.html and then you can use the MCONCAT() function =mconcat(D132:D146," ") -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Tservo" wrote in message ... I would LOVE to combine cells from the same column instead of cut & pasting information. - example D132 through D147 and have this combined information appear in D132. Is this possible? |
All times are GMT +1. The time now is 04:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com