Nested information in 1 cell

[SteveG53]

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.

[#2 · Accepted 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".

[#3]

Thanks, worked great.

[#4]

I wish to include a leading zero and not suppress it. For e example an account number may be 01234567

[#5]

Sorry I replied to your post accidently. I thought I was posting a question

[#6]

@JWPGolf 

Either set the number format to Text before entering data, or prefix the value with an apostrophe '