SOLVED

line break shows in Formula but doesn't appear in Value when enclosed by double quotes In Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-2923293%22%20slang%3D%22en-US%22%3Eline%20break%20shows%20in%20Formula%20but%20doesn't%20appear%20in%20Value%20when%20enclosed%20by%20double%20quotes%20In%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2923293%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20365%20v16.54%20on%2027%20%22%2C%20late%202015%20Mac%2C%20running%20Big%20Sur%2011.6%3C%2FP%3E%3CP%3EWhen%20I%20type%20formula%204%20characters%20%3D%22rr%20followed%20by%20alt%2Breturn%20followed%203%20charaters%20ss%22%26nbsp%3B%20%2C%3C%2FP%3E%3CP%3EThe%20formula%20line%20displays%3C%2FP%3E%3CP%3E%3D%22rr%3C%2FP%3E%3CP%3Ess%22%3C%2FP%3E%3CP%3EBut%20the%20value%20displayed%20in%20the%20cell%20is%3C%2FP%3E%3CP%3Errss%3C%2FP%3E%3CP%3Ewhile%20typing%20'rralt_returnss%20in%20the%20formula%20line%20displays%20properly%20as%20the%20cell%20value%3C%2FP%3E%3CP%3Err%3C%2FP%3E%3CP%3Ess%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20create%20a%20line%20break%20within%20a%20double%20quotes%20forumla%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2923293%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2923582%22%20slang%3D%22en-US%22%3ERe%3A%20line%20break%20shows%20in%20Formula%20but%20doesn't%20appear%20in%20Value%20when%20enclosed%20by%20double%20quotes%20In%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2923582%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F165657%22%20target%3D%22_blank%22%3E%40Gordon%20Peterson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMake%20sure%20that%20you%20turn%20on%20Wrap%20Text%20for%20the%20cell%20with%20the%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Excel 365 v16.54 on 27 ", late 2015 Mac, running Big Sur 11.6

When I type formula 4 characters ="rr followed by alt+return followed 3 charaters ss"  ,

The formula line displays

="rr

ss"

But the value displayed in the cell is

rrss

while typing 'rralt_returnss in the formula line displays properly as the cell value

rr

ss

 

Is there a way to create a line break within a double quotes forumla?

2 Replies
best response confirmed by Gordon Peterson (New Contributor)
Solution

@Gordon Peterson 

Make sure that you turn on Wrap Text for the cell with the formula.