Results 1 to 3 of 3

Thread: How can I force a line break in a single cell?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2011
    Location
    WICHITA KS
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How can I force a line break in a single cell?

    I've combined values from columns A and B using the formula below

    =A1&" "&B1

    value displays in column C like

    dataA dataB

    What I would like to do is insert a formula between the &'s that would force a line break so value of cell would display like

    dataA
    dataB

    Note: word wrap is not an option, as the length of data in column A can
    vary in length


    Any quick and clever fixes available?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How can I force a line break in a single cell?

    You can use

    =A1&CHAR(10)&B1

    but you do need to enable WordWrap.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Dec 2011
    Location
    WICHITA KS
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How can I force a line break in a single cell?

    Yup! That does it...Thank you Juan!

Some videos you may like

User Tag List

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
  •