Forum Discussion

SteveG53's avatar
SteveG53
Copper Contributor
Sep 27, 2022
Solved

Nested information in 1 cell

I am trying to create a formula that will nest several pieces of information in 1 cell.  I want to add the Alt+Enter command into my formula to start a new line in the cell but not sure how to execut...
  • Riny_van_Eekelen's avatar
    Sep 27, 2022

    SteveG53 Insert &CHAR(10)& in your formula to insert a line feed. For example=

     

    ="Line 1"&CHAR(10)&"Line 2"

     

    should return this:

    Don't forget to format the cell to "wrap text".

     

Resources