We can write a custom function to do that. Here is one:
For example, let's say that in cell A1 we wanted to combine the cells from range B1 to Z1. Then, simply enter this formula in A1:Code:Function CombineColumn(myRange As Range) Dim cell As Range For Each cell In myRange If Len(cell) > 0 Then CombineColumn = CombineColumn & cell.Value End If Next cell End Function
If you do not know what row the data will end in, simply pick some range that you know the data will never exceed, i.e. B1:IV1
Edit: Sorry, I originally had it set up for rows, not columns, in the example, though the same function will work!