CHAR(10) in formulas

V

vezerid

Hi all,

I thought I would be getting the newline effect if I used

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

Instead it is displaying a small square in place of linefeed and keeps
everything in the same line. Strange thing is, if I am in a row below
and I start typing A, autocomplete shows it with the linefeed. If I
finalize the entry (non-formula now), it has two lines as it was
desired in the first place.

Am I missing something?

Regards,
Kostis Vezerides
 
D

Dave Peterson

Format|cells|Alignment tab|check wrap text


Hi all,

I thought I would be getting the newline effect if I used

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

Instead it is displaying a small square in place of linefeed and keeps
everything in the same line. Strange thing is, if I am in a row below
and I start typing A, autocomplete shows it with the linefeed. If I
finalize the entry (non-formula now), it has two lines as it was
desired in the first place.

Am I missing something?

Regards,
Kostis Vezerides
Click to expand...
 
Top