Home

Alt+Enter does nothing

%3CLINGO-SUB%20id%3D%22lingo-sub-650247%22%20slang%3D%22en-US%22%3EAlt%2BEnter%20does%20nothing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650247%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys.%3CBR%20%2F%3EI%20am%20trying%20to%20get%20a%20line%20break%20in%20lists%20but%20every%20time%20I%20press%20Alt%2BEnter%20absolutely%20nothing%20happens.%3CBR%20%2F%3E%3CBR%20%2F%3EAnyone%20can%20drop%20in%20to%20help%20please%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-650247%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAlt%2BEnter%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELine%20break%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-650262%22%20slang%3D%22en-US%22%3ERE%3A%20Alt%2BEnter%20does%20nothing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650262%22%20slang%3D%22en-US%22%3E%3CP%3EI%20suspect%20you%20have%20been%20successful%20in%20inserting%20an%20ASCII%2010%20character%20but%20you%20do%20not%20have%20'Wrap%20text%22%20enabled%20for%20the%20cell%20so%20the%20display%20does%20not%20show%20multiple%20rows.%20The%20array%20formula%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%20CODE(%20MID(%20ref%2C%20%7B1%2C2%2C3%2C4%7D%2C%201%20)%20)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Ewill%20test%20a%20four%20character%20string%20to%20see%20whether%20a%2010%20is%20present.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Monica_Moura
Occasional Visitor

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!

1 Reply

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies