Forum Discussion
Monica_Moura
May 27, 2019Copper Contributor
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!
PeterBartholomew1
May 27, 2019Silver Contributor
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.