Do you want the results to appear in one column? If so, try this (assuming
data is in A1:E3) and copy down:

=IF(COUNTA(A1:E1),SUBSTITUTE(TRIM(A1&" "&B1&" "&C1&" "&D1&" "&E1)," ",",
")&";","")

If you want them in separate columns, use the formula above, then use
Data/Text To Columns using Space as the delimiter.



"veryeavy" wrote:

Hi All,

I am trying to write an automated commentary on some financial variances.

From here on my methos so far and a better method may diverge.

I have set up a grid where those variances I want to report are shown, e.g.

blank Loans blank Deposits blank
Cash blank blank Deposits Other
blank blank Shares blank blank

and I want the following displayed:

Loans, Deposits;
Cash, Deposits;
Shares;

EXACTLY like that ... (lining up on the same rows as the above is fine).

I am not sure if this IS difficult or I am just MAKING this difficult!

Really would appreciate any help as manually creating these commentaries is
tedious.

TIA and cheers,

Matt Geare
"veryeavy" on BBO :-)