Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Copy and Move sheet holding over 256 characters (Excel 2003 or 2000)

    HI LOUNGE,

    Any one know a way I copy an existing spreadsheet I have into another workbook if the sheet I am copying has over 255 characters in each row?
    currently when I use the right click on the sheet I want to copy check on create a copy and move to the a blank work book it loses the data in each row

    Thanks ahead

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy and Move sheet holding over 256 character

    Hi Markus

    Just making sure I get this right, are you saying that all the cells in columns A:IV contain data (equaling 256 columns) and you want to export all rows?
    Jerry

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

    Re: Copy and Move sheet holding over 256 characters (Excel 2003 or 2000)

    Instead of copying the entire sheet, create a new sheet in the other workbook, then select all cells in the source sheet, copy them, and paste into A1 in the new sheet

  4. #4
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy and Move sheet holding over 256 character

    What have create was basically a word document in excel. I have merge columns together (about 10 of them) and have typed in the merged columns I then adjusted the row and did a word wrap.

    A new workbook was created and I want to add the worksheet from the previous workbook to the new one. When I use the move / copy worksheet method I am prompted and told the I have exceeded 255 characters and data will be lost. Just wondering if there was a way around being prompted about the 255 characters

  5. #5
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy and Move sheet holding over 256 character

    Hi Marcus,

    Have you tried doing a CTRL-leftmouse-drag on the worksheet tab you want to copy?
    1. <LI>So you can see the two workbooks (source & destination) simultaneously, Choose Window | Arrange, then check either Vertical or Horizontal.
      <LI>While pressing the CTRL key down, hold your left mouse down on the source worksheet tab, and drag the tab to next to any worksheet tab in the destination workbook.
      <LI>Release your left mouse button, then the CTRL key.
    That makes a duplicate of the source worksheet in the destination workbook and leaves the orginial in your source workbook.

    Cheers,
    Rich

  6. #6
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy and Move sheet holding over 256 character

    Thanks, this method gives the same prompt though, 255 characters

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy and Move sheet holding over 256 character

    The best you can do is copy the sheet, then go back, copy the old sheet's cells and paste them into the new sheet.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Copy and Move sheet holding over 256 characters (Excel 2003 or 2000)

    A workaround.

    Using string formulas find out the Length (Function Len) of each cell.
    For those over 256 use string formula Mid to break up too long cells
    By example

    1. In a new empty cell put the formula =Mid(A1,1,255) where A1 references the cell that is too long
    2. In a second new cell Mid(A1.256.511)
    Continue until all text has been cut down
    Then using copy then paste special turn the new cells from formulas to Values.
    Latly delete the too long Text.
    Now you can copy the Sheet to anywhere.
    If you have a lot of work consider a Macro to repeat this task

    Tom Duthie

Posting Permissions

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