Can multiple cell results be displayed in a single cell?

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

Not ideal, but you could format cell A1 to wrap text, then put a formula in cell A1 as follows:-

=text(B1,"$##")&" "&text(B2,"$##")&" "&text(B3,"$##")

As long as you make the bits between the quotes long enough you should get the figures appearing in cell A1 as follows:-

$10
$15
$20

Brett

One way:

In A1:

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

Format A1 as "Wrap text" (or similar)


--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"FuadsCurse" <[email protected]> skrev i en meddelelse
news:[email protected]...
> 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

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

"FuadsCurse" wrote:

> 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