Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Return in Text Formula (XP)

    Using a formula like:

    ="Table "&TEXT(Table_Start+14,"##")&" Including ECON 1101"

    Is there a way to force a return before the Including? In other words, can I force the results of this formula to be on two lines?
    Ronny Richardson

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Return in Text Formula (XP)

    Yes, by inserting a CHAR(10) in the formula:

    ="Table "&TEXT(Table_Start+14,"##")&CHAR(10)&" Including ECON 1101"

    You should set the cell to wrap text in the Alignment tab of Format | Cells...

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Return in Text Formula (XP)

    Thanks Hans. It worked like a charm.
    Ronny Richardson

Posting Permissions

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