P PSG Member Aug 8, 2011 #1 I want to give an enter inside a cell containing text. The text inside cell should look like "Prakash is the name of the Person Singh is his middle name Gusain is his last name" All three line inside a cell as they are appearing above. Thanks in advance for looking into this.
I want to give an enter inside a cell containing text. The text inside cell should look like "Prakash is the name of the Person Singh is his middle name Gusain is his last name" All three line inside a cell as they are appearing above. Thanks in advance for looking into this.
Luke M Excel Ninja Staff member Aug 8, 2011 #3 Either hit Alt+Enter to being a new line, or, if you're concatenating items, you can use CHAR(10) (just make sure Word Wrap is enabled) E.g. =A2&CHAR(10)&A3&CHAR(10)&A4
Either hit Alt+Enter to being a new line, or, if you're concatenating items, you can use CHAR(10) (just make sure Word Wrap is enabled) E.g. =A2&CHAR(10)&A3&CHAR(10)&A4
