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