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.
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>
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>