Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Line Feed within String Formula (Not Manual or VBA)

  1. #1
    Join Date
    2nd August 2004
    Location
    Ontario - Canada
    Posts
    1,452

    Line Feed within String Formula (Not Manual or VBA)

    Okay, I know how to manual line feed within a cell (Alt+Enter) and I know how to do with the code.

    What I'm after is a line feed within a cell using a string formula, for example:

    =A2 & chr(10) & B2 & chr(10) & C2

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Line Feed within String Formula (Not Manual or VBA)

    Do you mean on a worksheet?

    This should work if you turn on word wrap in the cell with the formula.

    =A2 & CHAR(10) & B2 & CHAR(10) & C2

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    2nd August 2004
    Location
    Ontario - Canada
    Posts
    1,452

    Re: Line Feed within String Formula (Not Manual or VBA)

    Quote Originally Posted by norie
    =A2 & CHAR(10) & B2 & CHAR(10) & C2
    Yeppers, that works -- just 1 little letter more than in VBA's chr(10), duh!

    Thanks Norie.

    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. Insert Line Feed At Intervals In A Phrase
    By amer in forum EXCEL HELP
    Replies: 2
    Last Post: August 25th, 2007, 00:50
  2. Inserting a line feed during a replace
    By james.aldcroft in forum Excel and/or Word Help
    Replies: 3
    Last Post: June 29th, 2006, 23:33
  3. Line Feed
    By goldcoin in forum EXCEL HELP
    Replies: 1
    Last Post: July 27th, 2005, 02:41
  4. Line feed in a cell
    By ALW in forum EXCEL HELP
    Replies: 3
    Last Post: January 17th, 2005, 20:17
  5. Putting on Manual feed for one sheet within workbook
    By NIckNIckNIck in forum EXCEL HELP
    Replies: 5
    Last Post: October 15th, 2004, 17:53

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