Results 1 to 5 of 5

concatenate two text cells with a new line inbetween

This is a discussion on concatenate two text cells with a new line inbetween within the Excel Questions forums, part of the Question Forums category; Is ther an easy way to use a formula to concatenate two text cells and insert a new line between ...

  1. #1
    New Member
    Join Date
    Sep 2002
    Posts
    1

    Default

    Is ther an easy way to use a formula to concatenate two text cells and insert a new line between them.
    IE two cells are bert,fred end with
    bert
    fred

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    64,245

    Default

    On 2002-09-08 10:11, rogerstaff wrote:
    Is ther an easy way to use a formula to concatenate two text cells and insert a new line between them.
    IE two cells are bert,fred end with
    bert
    fred
    In C1 enter:

    =A1&CHAR(10)&B1

    Check Wrap text (for the formula cell) on the Alignment tab under Format|Cells.

  3. #3
    New Member
    Join Date
    Jun 2009
    Posts
    1

    Default Re: concatenate two text cells with a new line inbetween

    Quote Originally Posted by Aladin Akyurek View Post
    In C1 enter:

    =A1&CHAR(10)&B1

    Check Wrap text (for the formula cell) on the Alignment tab under Format|Cells.
    Thank You! This will work well with my macro to link data labels!

  4. #4
    New Member
    Join Date
    Dec 2010
    Posts
    6

    Default Re: concatenate two text cells with a new line inbetween

    Thanks...this answer saved me a ton of time this morning!

  5. #5
    New Member
    Join Date
    Nov 2007
    Posts
    19

    Default Re: concatenate two text cells with a new line inbetween

    Hi there

    Does anyone know how to show where the line break occurs in the excel cell. I.e. I want the square symbol which shows where the line break occurs in the excel cell.

    Thanks

    N

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com