CONCATENATE FORMULA

[sdsurzh]

Hi,


Suppose I have data from A1:A14 as shown below

1

2

3

4

5

6

7

8

9

10

11

12

13

14


I want a formula to combine all the numbers to one like

1,2,3,4,5,6,7,8,9,10,11,12,13,14


Thanks,

Suresh Kumar S

 

[xld]

Write yourself a UDF


Public Function Conc(rng As Range, Optional delim As String = ",")

Dim cell As Range

For Each cell In rng

Conc = Conc & cell.Value & delim

Next cell

Conc = Left(Conc, Len(Conc) - 1)

End Function`

 

[sdsurzh]

Thanks XLD