Im trying to convert a list of data into a block of text which I will then paste into a word document.
This formula will work, but I end up copying loads of blank cells/rows:
=C2 & CHAR(10) & CHAR(10) & C3 & CHAR(10) & CHAR(10) ... ect
Ive tried using this which fails when it hits a blank...