Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    carraige return in a cell (2003)

    I want to concatenate 2 bits of text with a carraige return between them in the same cell. I have seen this before but cannnot recall how to do this can anybody help?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: carraige return in a cell (2003)

    Select a target column and format it to wrap text. In that column use the formula =A!&char(10)&B1
    This assumes column C was the target.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: carraige return in a cell (2003)

    =A1&CHAR(10)&B1
    Quick fingers... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rudi

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: carraige return in a cell (2003)

    Thanks that works fine

Posting Permissions

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