How to Add Multiple Line Breaks to an Excel Formula with the CHAR(10) Function

%3CLINGO-SUB%20id%3D%22lingo-sub-2827077%22%20slang%3D%22en-US%22%3EHow%20to%20Add%20Multiple%20Line%20Breaks%20to%20an%20Excel%20Formula%20with%20the%20CHAR(10)%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2827077%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20working%20on%20a%20spreadsheet%20with%20a%20lengthy%20formula%20that%20I%20want%20to%20break%20up.%20I've%20already%20used%20the%20CHAR(10)%20function%20to%20add%20a%20line%20break%20between%20my%20formula%2C%20but%20wanted%20to%20know%20if%20it's%20possible%20to%20use%20this%20function%20to%20create%20multiple%20line%20breaks.%20Below%20is%20an%20example%20of%20what%20the%20formula%20looks%20like%20as%20text%20in%20the%20cell%20versus%20what%20I%20want%20it%20to%20look%20like%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECURRENT%3A%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%201%3C%2FP%3E%3CP%3EFormula%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPREFERRED%3C%2FP%3E%3CP%3EFormula%201%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2827077%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2827490%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20Multiple%20Line%20Breaks%20to%20an%20Excel%20Formula%20with%20the%20CHAR(10)%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2827490%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1179749%22%20target%3D%22_blank%22%3E%40MeganMck%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELike%20this%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0811.png%22%20style%3D%22width%3A%20275px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F316227i2145BDB0742897D7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0811.png%22%20alt%3D%22S0811.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2827570%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20Multiple%20Line%20Breaks%20to%20an%20Excel%20Formula%20with%20the%20CHAR(10)%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2827570%22%20slang%3D%22en-US%22%3EExactly%20what%20I%20needed.%20Thanks!%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone, 

 

I'm working on a spreadsheet with a lengthy formula that I want to break up. I've already used the CHAR(10) function to add a line break between my formula, but wanted to know if it's possible to use this function to create multiple line breaks. Below is an example of what the formula looks like as text in the cell versus what I want it to look like: 

 

CURRENT: 

Formula 1

Formula 2

 

PREFERRED

Formula 1

 

Formula 2

 

Thanks in advance for your help! 

2 Replies