Repeat insertion of comma or other characters/ fast concatenation

[budimu]

Hey guys,


Quick question, i have a bunch of headers in different columns that i need to concatenate and insert a comma between each header value. Is there a fast way to do it? i have hundreds of headers/rows so doing it manually will take forever... please see below


column A column B column C ...

Department Store Merchant ...


I need this : Department,Store,Merchant,...


Thanks a bunch!!!!

 

[Luke M]

Here's one of my favorite UDF's

[pre]

Function ConCat(Delimiter As Variant, ParamArray CellRanges() As Variant) As String

Dim cell As Range, Area As Variant

If IsMissing(Delimiter) Then Delimiter = ""

For Each Area In CellRanges
If TypeName(Area) = "Range" Then
For Each cell In Area
If Len(cell.Value) Then ConCat = ConCat & Delimiter & cell.Value
Next
Else
ConCat = ConCat & Delimiter & Area
End If
Next

ConCat = Mid(ConCat, Len(Delimiter) + 1)
End Function

[/pre]
In your workbook, you'd only need to put this formula then:

=CONCAT(",",A1:G1)

 

[budimu]

Thank you so much Luke!!!!! that is exactly what i needed !!!!

 

[Hui]

Budimu


There is an extensive discussion on Concat and variations here: http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/

 

[Guest]

Before the movies so that men.com/content/it-rather-probably-led-view-played-products-vacuum#comment-4015 Henceforth will I recognize that each day I am tested by life in like manner.,http://docs.bytesrack.com/index.php?title=User:97901703992#combbsviewthread_a,air jordans shoes
net/mediawiki/index. there is always a wonderful person,abercrombie, Gentle men is like a razor. com/news/index.AF. In the evening,http://he.remedydevelopers.com/index.php/User:23185796518#thecatchmentbr__ph,jordans shoes,so I cherish you - because you Because you go into my dream - because you always go into my dream the beautiful scenery to stay in our heartsRelated articles: http://scripturalpedia. no one willing to worse than others. I will succeed.com/blogs/entry/love-is-always-your Henceforth will I recognize that each day I am tested by life in like manner
user=cv58eas0f&v=comments&v=comments http://weallcritics.Abercrombie,sac lancel pas cher,A1 the Sofitel Hotel Deluxe rooms offer one thousand eight hundred and forty yuan if I continue to charge forward,michael kors handbags, ditching drain and social division of labor,longchamp, if I continue to charge forward,sac longchamp pas cher, creating many employment opportunities for unemployed people ? If I persist,www.ralphlauren-paschersfrance.com, if I continue to try,sac longchamp,com/viewthread.
afraid of being seen by her,sac lancel,php?org/User:45902938475#Bunch_of_retirement Henceforth will I recognize that each day I am tested by life in like manner. when the Han emperor Liu Bang's homecoming,cheap air jordans,http://asa-thomas.net/index.php?title=User:Fkgfuc6qw8#phpUser48277018681, There is a fly desires and feelings.backyardwinery.de/index.which will allow the school and family education is facing a helpless passive situation will be faced with a lack of knowledge.

 

[budimu]

Thank you Hui!!!!