- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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 to use the mouse move event in cells to read the comments in the cells||23||52|
|Excel macro sheet auto run and save to xlsx||5||16|
|Out of stack space (Error 28)||5||20|
|remove data validation/drop downs when moving row to another sheet||8||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!