Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / 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.
    VB:
    =A1 & CHAR(10) & A2 & CHAR(10) & A3 
    
    

    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, 17:50
  2. carriage return in formula
    By breakingstein in forum EXCEL HELP
    Replies: 4
    Last Post: August 23rd, 2005, 20:45
  3. Inserting Carriage Return in text strings
    By johnccc in forum EXCEL HELP
    Replies: 2
    Last Post: August 10th, 2004, 17:21
  4. Replies: 2
    Last Post: August 16th, 2003, 05:51
  5. Carriage Return in Message Body
    By Egad in forum Excel and/or Email Help
    Replies: 7
    Last Post: May 11th, 2003, 08: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