Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Worthington, Ohio, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merging Cells (Excel 2000)

    Good evening! I am trying to merge 2 pieces of info (vendor and address) so that they are in the same cell. Is there a way to do this? I've been cutting, using Alt+Enter and then pasting below the address below the vendor info. This happens in column A and again in the phone/fax and web address/email column. Is there any easier solution? Thank you!

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

    Re: Merging Cells (Excel 2000)

    If you have the 2 pieces of information in 2 separate cells, you can use a formula to concatenate them on two lines.
    Say that vendor is in Q4 and address in R4, then you can put this formula in A4:

    =Q4&CHAR(10)&R4

    Of course, text wrapping must be on. You can now fill this formula down as far as needed.

    When you're done, you can either hide the columns with the separate pieces of information, and keep the formulas, or you can copy the cells containing the formulas, and then paste special > values to get rid of the formulas; you can delete the columns with the individual pieces of information now, since they are not needed any more.

Posting Permissions

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