Can multiple cell results be displayed in a single cell?

[Guest]

Is it possible to display the contents of multiple separate cells in another
single cell?

If the results of several cells say B1, B2, and B3 are the amounts $10, $15
and $20, I would like to display them in cell A1 as follows:

$10
$15
$20

I could do this statically by using text and the 'Alt|Enter' function within
the cell. However, these amounts will change from time to time so I'd like a
link.

Is this possible or not?

Thanks for any help.

Brett

 

[Leo Heuser]

Brett

One way:

In A1:

="$"&B1&CHAR(10)&"$"&B2&CHAR(10)&"$"&B3&CHAR(10)

Format A1 as "Wrap text" (or similar)

 

[Guest]

Go to format>cells>alignment and turn on text wrap, then use

=TEXT(B1,"$0.00")&CHAR(10)&TEXT(B2,"$0.00")&CHAR(10)&TEXT(B3,"$0.00")

Makes sure the cell is large enough


You can also use =B1&CHAR(10)&B2 etc but then you won't get any currency
format, just the numbers

Regards,

Peo Sjoblom