CODEWITHSUNDEEP
excellistexcel-formulaconcatenation
Tyra
Tyra

Reputation: 105

Concat list in excel issue

I want to concat a list in the excel. using this

=CONCATENATE(TRANSPOSE(J2:J9)&",")

enter image description here

J is the column of the list (J2 to J9) . K is where the concat takes place. But the results shown above, it is not e.g. a,b,c,d,f,da,a,sd ??

Help please has been trying to figure out whole day

Upvotes: 0

Views: 67

Answers (1)

Rajput
Rajput

Reputation: 605

Then you can use this UDF function for Excel 2016.

=CONCATENATEMULTIPLE(J2:J9,",")

enter image description here

Function CONCATENATEMULTIPLE(Ref As Range, Separator As String) As String
Dim Cell As Range
Dim Result As String
For Each Cell In Ref
 Result = Result & Cell.Value & Separator
Next Cell
CONCATENATEMULTIPLE = Left(Result, Len(Result) - 1)
End Function

Upvotes: 1

Related Questions