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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
| 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" wrote in message
| ...
| for example, I want = "a" & "b" & "c" to appear thus:
| a
| b
| c
|
| in the same cell
|
|
|