Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Park City, Utah
    Posts
    189
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Multiple Line Text Formula (2003)

    I'm trying to create a complete address in the format:

    Full Name
    Address
    City State Zip

    in the last column of the attached spreadsheet, but I cannot figure out if it is possible to enter a new line in the formula:

    =L1&
    G1&
    H1&" "&I1&" "&J1

    Is it possible?

    Thanks!

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

    Re: Multiple Line Text Formula (2003)

    Concatenate with CHAR(10) to insert a line feed:

    =L1&CHAR(10)&G1&CHAR(10)&H1&" "&I1&" "&J1

    You must also tick the Wrap Text check box in the Alignment tab of the Format | Cells dialog, otherwise the line feed will be displayed as a square.

Posting Permissions

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