+ Reply to Thread
Results 1 to 5 of 5

Copying many cells, drop content into one cell? THANKS!

  1. #1
    Registered User
    Join Date
    07-07-2009
    Location
    Massillon, Ohio, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question Copying many cells, drop content into one cell? THANKS!

    I have a document I was directed to fill in. I was instructed to only use a certain number of characters and then drop into another cell below it for paragraphs of text.

    I have now been told they made a mistake, need me to copy all the related cells for a specific paragraph and drop them into a single cell.

    Can I copy the text in multiple cells, and then drop the cell formating of those copied cells and drop the content into one single cell. Either word wrapping the content or soft returns for what looks like paragraphs again?


    Thanks for your help in advance!
    Last edited by WillyBoard; 07-09-2009 at 10:30 AM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Copying many cells, drop content into one cell?

    You cannot use formulas to apply multiple formats to various text in a cell, but you can collect text strings from various sources and concatenate them into a single cell, including line feeds.

    But this stuff is fraught with problems, so rather than just guess at your need, mockup a sample workbook showing the dilemma and your desired results, point out where the results came from if not obvious in your sample data.

    Then click GO ADVANCED and use the paperclip icon to post up your workbook.

  3. #3
    Registered User
    Join Date
    07-07-2009
    Location
    Massillon, Ohio, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Copying many cells, drop content into one cell?

    Here is a sample of my needs... I have to wait until I am back at work to verify which vrs of excel I am using. Thanks again..
    Attached Files Attached Files

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Copying many cells, drop content into one cell?

    String concatenation can be a bit of a frustrating process, but it's doable. You can keep adding "needs" to this to make it unmanageable, but the ability to point to a range of cells and say "concatenate all these text strings into a single cell"...that's not that hard to ADD INTO your spreadsheet.

    I have several User Defined Functions (UDFs) that can be added to your sheet to give you the new function. The simplest I use is called ConCatRange() and it doesn't take any parameters other than the range of cells you want to join.

    Please Login or Register  to view this content.
    How to install the UDF:

    1. Open up your workbook
    2. Get into VB Editor (Press Alt+F11)
    3. Insert a new module (Insert > Module)
    4. Copy and Paste in your code (given above)
    5. Get out of VBA (Press Alt+Q)
    6. Save your sheet

    The UDF is installed and ready to use.

    It's used in your sheet, for example, like this:

    =ConCatRange(G1:G6)

  5. #5
    Registered User
    Join Date
    07-07-2009
    Location
    Massillon, Ohio, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Thumbs up Re: Copying many cells, drop content into one cell?

    Impressive... I will have to get some additional assistance from someone else in the office to use the information you gave me, but I certainly appriciate your help thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1