Forum Discussion
Alt+Enter does nothing
Hi guys. I am trying to get a line break in lists but every time I press Alt+Enter absolutely nothing happens. Anyone can drop in to help please? Thanks in advance!
I suspect you have been successful in inserting an ASCII 10 character but you do not have 'Wrap text" enabled for the cell so the display does not show multiple rows. The array formula
= CODE( MID( ref, {1,2,3,4}, 1 ) )
will test a four character string to see whether a 10 is present.
Even I am facing same problem. Wrap is enabled. This problem is persisting for last 2 years since I installed it
- Have you tried the second part of the recommendation? Namely, use MID to separate out individual characters from the string and CODE to allow you to see which character is selected. The line feed character is non-printing but should give a code value of 10 if it is present.
That should help narrow the problem down to one of string content or formatting.