Announcement

Collapse
No announcement yet.

Inserting Carriage Return Character in Formulas

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Inserting Carriage Return Character in Formulas

    I want to compose a formula that will result in not only combining some cells together but also will insert a carriage return in some spots. However, I don't know how to do this.

    e.g.
    If A1 = Joe Smith, A2 = President, A3 = ABC Company

    I want to create a formula in A4 that concatenates the three cells and produces

    Joe Smith
    President
    ABC Company

    which I can later copy and paste into other applications to use.

    What would that formula look like?

  • #2
    Re: Inserting Carriage Return Character in Formulas

    wont paste special> transpose achieve the same thing?

    Comment


    • #3
      Re: Inserting Carriage Return Character in Formulas

      Hi,

      This formula in A4 but you need to set Wrap text on otherwise you will just see little white boxes between the items.
      =A1 & CHAR(10) & A2 & CHAR(10) & A3

      Cheers
      Andy

      Comment


      • #4
        Re: Inserting Carriage Return Character in Formulas

        Thanks, I knew it had to be simple!

        Comment

        Working...
        X