CHAR(10) in formulas

  • Thread starter Thread starter vezerid
  • Start date Start date
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Char(10) and blank lines 6
concatenate, char(10), and double quotes 3
How to ignore embedded linefeed in CSV quoted text fields? 1
Concatenate with Line Feed not working 3
CONCATENATE involving CHAR(13) and CHAR(10): "" marks when copy/pasteto text editor [???] 2
How do I return text in between char(10) 1
ALT-ENTER in a concatenate formula 2
Complex formula help 4

Back
Top