Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Inserting Carriage Return Character in Formulas

  1. #1
    Join Date
    17th September 2005
    Posts
    2

    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?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    12th January 2005
    Location
    Dusseldorf
    Posts
    232

    Re: Inserting Carriage Return Character in Formulas

    wont paste special> transpose achieve the same thing?

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    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.
    [vba]=A1 & CHAR(10) & A2 & CHAR(10) & A3[/vba]

    Cheers
    Andy


  4. #4
    Join Date
    17th September 2005
    Posts
    2

    Re: Inserting Carriage Return Character in Formulas

    Thanks, I knew it had to be simple!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Carriage Return - Chr(10)
    By JMAN in forum EXCEL HELP
    Replies: 6
    Last Post: May 26th, 2006, 18:50
  2. carriage return in formula
    By breakingstein in forum EXCEL HELP
    Replies: 4
    Last Post: August 23rd, 2005, 21:45
  3. Inserting Carriage Return in text strings
    By johnccc in forum EXCEL HELP
    Replies: 2
    Last Post: August 10th, 2004, 18:21
  4. Replies: 2
    Last Post: August 16th, 2003, 06:51
  5. Carriage Return in Message Body
    By Egad in forum Excel and/or Email Help
    Replies: 7
    Last Post: May 11th, 2003, 09:26

Bookmarks

Posting Permissions

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