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

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" skrev i en meddelelse
...
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 formatcellsalignment and turn on text wrap, then use

=TEXT(B1,"$0.00")&CHAR(10)&TEXT(B2,"$0.00")&CHAR(1 0)&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