Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
and the function to enter into the spreadsheet is here:
Function strcat(rng As Range, Optional dlm As String = ",", Optional bUseFormat As Boolean = True) Dim cel As Range For Each cel In rng If cel.Value <> "" Then strcat = strcat & dlm & IIf(bUseFormat, cel.Text, cel.Value) Next cel strcat = Mid$(strcat, Len(dlm)) End Function
Something I noticed just recently that I had not noticed previously is that when using this code, a delimiter is inserted prior to the first cell's contents. For example, if the contents of five cells to be concatenated are:
|How do I get the final projected value when using the Excel VBA Trendlines.Add method to add a trendline to a chart?||4||28|
|Make a Cell act like a Date||7||38|
|Excel 2010 - Selecting and copying cells from areas with hidden rows is not working||3||18|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!