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

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

in the same cell

Hi

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

Andy.

"DViolette" <DViolette@discussions.microsoft.com> wrote in message
news:52A2F3DC-5912-4B6C-A3FD-16C5EF0ECB03@microsoft.com...
> for example, I want = "a" & "b" & "c" to appear thus:
> a
> b
> c
>
> in the same cell

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.
>
> "DViolette" <DViolette@discussions.microsoft.com> wrote in message
> news:52A2F3DC-5912-4B6C-A3FD-16C5EF0ECB03@microsoft.com...
> > for example, I want = "a" & "b" & "c" to appear thus:
> > a
> > b
> > c
> >
> > in the same cell
>
>
>

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

"DViolette" <DViolette@discussions.microsoft.com> wrote in message
news:8C15EDBA-7F2A-4323-ABCA-144506BD45E7@microsoft.com...
| 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.
| >
| > "DViolette" <DViolette@discussions.microsoft.com> wrote in message
| > news:52A2F3DC-5912-4B6C-A3FD-16C5EF0ECB03@microsoft.com...
| > > for example, I want = "a" & "b" & "c" to appear thus:
| > > a
| > > b
| > > c
| > >
| > > in the same cell
| >
| >
| >