CHAR(10) in formulas
 

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

CHAR(10) in formulas
 

Format|cells|Alignment tab|check wrap text



vezerid wrote:

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

--

Dave Peterson

CHAR(10) in formulas
 

Wow, Dave thanks!

My mind did not go at all in this direction.

Regards,
Kostis


Dave Peterson wrote:
Format|cells|Alignment tab|check wrap text



vezerid wrote:

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

--

Dave Peterson