• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Enter with in a Cell

P

PSG

Member
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.
 
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
 
You must log in or register to reply here.
Back
Top