Forum Discussion

TheOldPuterMan's avatar
TheOldPuterMan
Brass Contributor
Apr 06, 2020
Solved

Excel 365 Insider (2004 Click to run) CONCAT function with CHAR(10) to insert line feed not working

I'm attempting to insert line feeds into text using a function. From everything I can find the CHAR(10) used within CONCAT, TEXTJOIN or plain old "&" should give me the results I'm looking for but......
Formulas and Functions
  • ExcelExciting's avatar
    ExcelExciting
    Apr 06, 2020

    hi TheOldPuterMan 

     

    You formula is correct, you need to wrap text 

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer.

     

     

ExcelExciting's avatar
ExcelExciting
MVP
Apr 06, 2020

hi TheOldPuterMan 

 

You formula is correct, you need to wrap text 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

 

 

TheOldPuterMan's avatar
TheOldPuterMan
Brass Contributor
Apr 06, 2020
Thank you! That wasn't mentioned anywhere and I was too naive to consider it.
TheOldPuterMan

Resources