How do I put each member of string concatenation in its own line?

[Guest]

for example, I want = "a" & "b" & "c" to appear thus:
a
b
c

in the same cell

 

[Guest]

Hi

Try typing a then Alt+Enter then b then Alt+Enter and then c

Andy.

 

[Guest]

sorry, I wasn't clear in my question. It needs to happen within a formula
without manual typing.

Say the formula is
= a12 & b34 & c45

I want these three stacked in a cell without having to manually type anything.

 

[ScottO]

Change format to Wrap Text
Then change your formula to
=a12&Char(10)&b34&Char(10)&c45
Rgds,
ScottO

| sorry, I wasn't clear in my question. It needs to happen within a formula
| without manual typing.
|
| Say the formula is
| = a12 & b34 & c45
|
| I want these three stacked in a cell without having to manually type
anything.
|
|
|
| "Andy" wrote:
|
| > Hi
| >
| > Try typing a then Alt+Enter then b then Alt+Enter and then c
| >
| > Andy.
| >
| > | > > for example, I want = "a" & "b" & "c" to appear thus:
| > > a
| > > b
| > > c
| > >
| > > in the same cell
| >
| >
| >