Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    CONCATENATE with a CHR(13) (xl 2003)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers

    OK I have a worksheet with data in two columns. Data in column A needs to be Concatenated with data in column B.

    What I would like to do is to add a carriage return character so that data from Column B will be on the 2nd line of the cell entry.

    How do I add the CHR(13) in the concatenate formula and have it being recognized as a special character vs a string.

    I tried <font color=blue>=CONCATENATE(A1,CHAR(13),B1)</font color=blue> but it did not work?! <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    Any ideas?

    Thanks a Million
    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

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

    Re: CONCATENATE with a CHR(13) (xl 2003)

    Use CHAR(10) instead of CHAR(13)

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

    Re: CONCATENATE with a CHR(13) (xl 2003)

    And make sure that Wrap Text has been set for the cells with the formulas (in the Alignment tab of Format | Cells), otherwise the CHAR(10) will be displayed as a box character.

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: CONCATENATE with a CHR(13) (xl 2003)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Hans

    I tried CHAR(10) but I had the cells too wide, so now it works OK. Thanks

    Hey since I am asking, is there a way to reserve the formats with the Concatenate formula?

    I would like to have the entries from column A be font size 36 and the entries from column B to be font size 12.

    Any ideas?

    Thanks

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

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

    Re: CONCATENATE with a CHR(13) (xl 2003)

    You cannot format parts of the result of a formula, only the result as a whole.

    (See the recent thread starting at <post:=672,522>post 672,522</post:> for some alternatives, although in a different context)

  6. #6
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: CONCATENATE with a CHR(13) (xl 2003)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Hans

    Thanks Hans

    I am writing some code now to do what I want to do. It should be interesting.

    Thanks for all your help.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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