Results 1 to 7 of 7
  1. #1
    Star Lounger skip's Avatar
    Join Date
    May 2002
    Location
    Connecticut, USA, Connecticut, USA
    Posts
    50
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Hi,
    Office 2000 SP3
    I need to copy a range of cells (ex. G2 - G30) and then paste them all into one cell. Is that possible? The only alternative is to type each cell into the new one. : (
    Thanks for the help.

    Skip
    Skip Whitten, MCITP
    http://www.skipwhitten.info

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Do you want the contents of the original cells to run together, or to be separated by spaces, or by line breaks, or ...?


  3. #3
    Star Lounger skip's Avatar
    Join Date
    May 2002
    Location
    Connecticut, USA, Connecticut, USA
    Posts
    50
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HansV View Post
    Do you want the contents of the original cells to run together, or to be separated by spaces, or by line breaks, or ...?
    I want the contents separated by a semi colon ; (ex. O-20884;O-20887;O-20897)

    Thanks,

    Skip
    Skip Whitten, MCITP
    http://www.skipwhitten.info

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    See the thread Concatenate a range of cells.

    Copy the MyJoin function from Pieterse's reply into a standard code module (in the Visual Basic Editor). You can then use a formula such as

    =MyJoin(G2:G30,";")

  5. #5
    Star Lounger skip's Avatar
    Join Date
    May 2002
    Location
    Connecticut, USA, Connecticut, USA
    Posts
    50
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Thanks Hans,
    I need to bone up on VB. Good excuse!!

    Regards,

    Skip
    Skip Whitten, MCITP
    http://www.skipwhitten.info

  6. #6
    Star Lounger skip's Avatar
    Join Date
    May 2002
    Location
    Connecticut, USA, Connecticut, USA
    Posts
    50
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by skip View Post
    Thanks Hans,
    I need to bone up on VB. Good excuse!!

    Regards,

    Skip
    .
    OK, I got VB to work (both MyJoin & JoinIt) but I'm having a hard time understanding how I can use this with any worksheet. How can I load this 'permanently' into my Excel installation.

    Thanks,

    Skip
    Skip Whitten, MCITP
    http://www.skipwhitten.info

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If you copy the code into a module in your personal macro workbook Personal.xls, you'll be able to use the function in any workbook. You'll have to change the formula slightly:

    =Personal.xls!MyJoin(G2:G30,";")

    (But if you give the workbook to someone else, the formula won't work unless the recipient also copies the code into their Personal.xls; if the workbook will be used by others it's better to copy the code into a module in the workbook itself).

    See Legare Coleman's Personal.xls Tutorial.

Posting Permissions

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