Concatenate all cells in a column up to the 1st cell that is empty

[dmp3lic]

I am trying to concatenate all the cells in a column up to the 1st cell that is empty.

So in cell A1 where it says "FORMULA", this is the cell I want to have the results as "Excel is really a lot of fun." or A2+A3+A4+A5+A6+A7+A8.

	A	B	C
1	FORMULA
2	Excel
3	is
4	really
5	a
6	lot
7	of
8	fun.
9
10

<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>

 

[63falcondude]

You can use the TEXTJOIN function with Excel 2013+.

If you have an older version of Excel, you can write a TEXTJOIN UDF
Source:TEXTJOIN function | Get Digital Help - Microsoft Excel resource

or use a formula such as =TRIM(A2&" "&A3&" "&A4&" "&A5&" "&A6&" "&A7&" "&A8&" "&A9&" "&A10)