Sep 27 2022 10:15 AM
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 execute this. Any help would be appreciated. Thanks.
Sep 27 2022 10:55 AM
Solution@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".
Sep 27 2022 11:18 AM
Sep 27 2022 11:20 AM
Sep 27 2022 01:21 PM
Either set the number format to Text before entering data, or prefix the value with an apostrophe '
Sep 27 2022 10:55 AM
Solution@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".