How to combine text from many cells without writing each cell adress, just the scope of cells?
Can I combine tex from cells A1 to A3 in a faster way than writing a formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text from a really huge number of cells, like from B1 to B3489, and I want to do it without writing every cell adress.