Insert newline in cell through formula (excel 2003)

[Bart Wouters]

Hi all,

I'm having troubles to simulate the alt+enter character into a formula of
excel 2003.

In previous versions, I could use something like

= "A" & char(10) & "B"

In this version, instead of displaying A and B in the same cell, on another
line, I get A (a square symbol/character) B.

If I'm doing a copy/paste special (values), I have the same display. If I
enter the cell using F2 and simply pressing Enter, the square character is
replaced by the newline.

What am I doing wrong ? Have to immediatly have the newline !

Thanks in advance !
Bart

 

[Rick Rothstein \(MVP - VB\)]

On the Format Cell's Alignment tab, select Wrap Text from the Text Control
section.

Rick

 

[bj]

I have 2003 and your formula works OK for me.
with the result being
A
B
if wrap is selected and
AB
if not.

what is your default font. it is acting like it is not recognizing the
Char(10)