Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2010 copy/paste giving incorrect results.

    I am running Excel 2010 on Windows 7 64 bit version, and I'm having a problem with copy and paste.

    I'm attempting to copy and paste a blocks of cells from one worksheet to another and get two different types of errors on the paste.

    If I select cells A1 - A5 on one sheet, when I paste into the second sheet I might get the data from cells A1, A4, and A5 pasted into cells A1, A2, and A3 on the second sheet.
    Or I might get something like A1, zzz, A2, A3, zzz, zzz,A4, A5 in cells A1-A8. The zzz is a value that previously was in the cells, but has long been deleted.

    That is:
    Select
    AAAAA
    BBBBB
    CCCCC
    DDDDD
    EEEEE

    Get after paste:
    AAAAA
    DDDDD
    EEEEE

    or

    AAAAA
    zzz
    BBBBB
    CCCCC
    zzz
    zzz
    DDDDD
    EEEEE




    I've tried to get rid of any kind of invisible formatting by pasting first into Notepad and then copying the text out, but that does not help.

    Note: My data includes street names from Paris, so my text does include special alphabetic characters and hyphens

    Is this a recognized problem with a known solution?

  2. #2
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,078
    Thanks
    0
    Thanked 259 Times in 248 Posts
    I copied your list of 5 items and tried in Excel 2010 and also in LibreOffice Calc 4.3, appeared to Copy and Paste correctly on 3 sheets. I have only English versions of programs.

  3. #3
    New Lounger
    Join Date
    Sep 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Berton View Post
    I copied your list of 5 items and tried in Excel 2010 and also in LibreOffice Calc 4.3, appeared to Copy and Paste correctly on 3 sheets. I have only English versions of programs.
    I suspect that others will get the same result. I suspect that there is some form of corruption in my worksheet that I don't know how to clear.

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 650 Times in 592 Posts
    krf,

    If you copied the text from the internet and pasted into your cells, you often get hidden non-printable formatted characters. Try the clean function: =CLEAN(A1).

    HTH,
    Maud

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Are all the rows unhidden in both the copy and the source?

    Steve

Tags for this Thread

Posting Permissions

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