Line break function?

[Matt]

I have the following function

="A"&"B"&"C"

which gives: ABC

Is there a way to insert line breaks so that instead of displaying
ABC, it will display:
A
B
C

 

[Gord Dibben]

="A" & CHAR(10) & "B" & Char(10) & "C"

Format to Wrap Text and Row>Autofit.


Gord Dibben MS Excel MVP