We can use this in VBA Module
Function ConcatRange(Rng As Range)
Dim i As Range
For Each i In Rng
ConcatRange = IIf(IsEmpty(ConcatRange), i.Value, ConcatRange &
", " & i.Value)
Next
End Function
Rgds,
[dp]
Pada 02/07/2013 21:15, KAUSHIK SAVLA menulis:
Hi Team,
I am havin
Kaushik,
PFA, to see the formula.
On Tue, Jul 2, 2013 at 5:15 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> I am having some data in Cell A1 to A100 and I want to concatenate
> range of data from A1 to A100 with comma as seperator.
>
> Example:
>
> Cells
> A1 10
> A2 20
> A3
Thanks Vijay and Ahmed to resolve the query.
Regards,
Kaushik
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread title
Kaushik:
As your values are in Cells A1 to A2 write in Cell B1 formula =A1 and in
cell B2 = concatenate(B1,",",B2) and now this cell B2
formula copy and paste from cell B3 to B100 then finally the result you are
looking for will be in B100.
Hope this helps
On Tue, Jul 2, 2013 at 5:15 PM
Hi Kaushik,
Please check attached file.
On Tue, Jul 2, 2013 at 7:45 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> I am having some data in Cell A1 to A100 and I want to concatenate
> range of data from A1 to A100 with comma as seperator.
>
> Example:
>
> Cells
> A1 10
> A2 20
> A3
Hi Team,
I am having some data in Cell A1 to A100 and I want to concatenate
range of data from A1 to A100 with comma as seperator.
Example:
Cells
A1 10
A2 20
A3 30
&so on
I want result as 10, 20, 30 & so on.
Please help.
Warm Regards,
Kaushik Savla
--
Are you =EXP(E:RT) o
